If specific word in 1 column, 5 adjacent columns get automated text

    Hi All,


    I have been trying to solve this problem but can’t seem to. I would be grateful if one of you awesome excel users would be able to help.
    I have attached a sample sheet below.
    What I’m trying to achieve is,
    If Column F is Yes then sheet stays as it is. E.g. Column F/ Row 4
    If Column F is No then Column G, H, I, J, K automatically come with the word N/A. E.g. Column F/ Row 5
    All your help will be truly appreciated.


    Regards,


    VMAL

    Re: If specific word in 1 column, 5 adjacent columns get automated text


    You can enter a formula in G4 copied across the columns and down.


    =IF($F4="NO","N/A","")


    (Note: You will need to temporarily turn off Error Alert in the data validation to enter the formulas).


    (Note2: Once a choice is selected in the drop downs in column G:K, you will loose the formula in those cells permanently).

    Where there is a will there are many ways. Finding one that works for you is the challenge!

    Re: If specific word in 1 column, 5 adjacent columns get automated text


    Hi,


    Perfect. Thanks for your help.


    Regards,


    VMAL

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login