Forum Discussion
If, Then formula from multiple columns
Hi there!
I'm doing a mail merge for a scholarship award letter.
The data report that we're running doesn't specify where the funds will be deposited in words. it only has a header of locations a, b, c, etc. and underneath it says "yes" or is left blank. Right now I have this on a sheet labeled "data"
The merge is pulling from sheet 2 labeled "merge"
in the award letter we need to insert "your award will be applied to <<location>>"
so what i've done so far is made additional columns with this formula: =IF(BG3="Yes","LOCATION A",0)
where I'm stuck is: how do I take multiple columns of information (one column containing a word and the rest 0) and tell a cell on another sheet to pull the word out and leave the zeros.
If there's a better way to take the initial data and narrow down this information into Sheet 2 "merge"?
2 Replies
Please clarify the logic of Location selection (i.e. a, or b, or c)
It's not altogether clear what your various sheets contain, where that one formula resides (on the "merge" sheet?)....but IF what seems to be the case actually is, perhaps you need to familiarize yourself with the IFS function, and employ it rather than IF.
So, putting it all in one column on the merge sheet, the formula could read (and I'm making some assumptions here)
=IFS(BG3="Yes","Location A",BH3="Yes","Location B",BI3="Yes","Location C.....)
That would run through those several columns, the majority of which are blank, pick up the one that has "Yes" and enter the corresponding location name.
