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,
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!