I want to do a serial IF this then that formula across more than one column. Please help!

I want to do a serial IF this then that formula across more than one column. Please help!

My =IF([email protected]="Name1", "Parent1") and it worked to bring the Parent name into the @row, but I am trying to also add a few other Child/Parent combos into it as well. For example,

In the Parent Column, I want to combine =IF([email protected]="Name1", "Parent1"), OR =IF([email protected]="Name2", "Parent2"), OR =IF([email protected]="Name3", "Parent3"), etc.

I also want to add other functions like, =IF([email protected]="Name1", "Sibling1" in the [email protected] ... Is this possible? If so, how can I combine these? I want one huge formula to copy down the column so the other columns are automatically filled out when I select the child.


Thanks in advance!

Answers

  • You could combine if statements by doing =IF([email protected]="Name1", "Parent1", IF([email protected]="Name2", "Parent2", IF([email protected]="Name3", "Parent3", ""))).

    Instead I recommend using a Vlookup function, it would be something like =Vlookup([email protected], (selected the table with all the parent/child info), 2, false)

    Basically it will look up the "Child" name in the Table that you select and the output would come from the column you select in the table(2 in my example). You could use this formula for the Siblings or any other data you have as well.

    Regards,

    Josh

  • Hi Josh,

    Thanks for answering. The first example you provided worked! I would love to learn about the second example, but am not quite catching it. If I select, [email protected] then highlight the row with columns that I would like copied over, it still does not copy it over. I think I am missing what the number and the "false" are doing?

  • Okay, I have figured out the number and the false... but still now luck on getting multiple columns in one row to auto-populate when I put the child's name into the row.


    For example, this works to auto-populate the one column that I put this formula in:

    =IF([email protected] = "Name1", "Service1", IF([email protected] = "Child1", "Service2", IF([email protected] = "Child3", "Service3")))

    But is there a way to have the Name, Service, Parent, Cost all auto-populate when I put the child's name into the row?

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Sue Crawford (admin)

    Hi Sue,

    Not sure I follow!

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andree,

    I managed to find a work around! Thanks for your response!

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 03/16/20

    @Sue Crawford (admin)

    Excellent!

    Happy to help!

    Glad to hear that you solved it!

    How did you solve it?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.