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