I'm trying to run a nested if function across a series of columns and concatenate the values where the criteria is true. I'm evaluating a series of flags each in a different column and if the flag is set to Y, I'm concatenating the label in a string for output. If the value is blank, I'm getting a FALSE value returned from the formula and the rest of the if statements aren't executed. Trying to do this without getting into code/macros. Any ideas?
Data - Row 1 has the flag names (flag 1, flag 2, etc...). Row 2 has the indicators.
Here is the formula - =IF(B2="Y",B1&" "&IF(C2="Y",C1&" "&IF(D2="Y",D1&" "&IF(E2="Y",E1&" "&IF(F2="Y",F1&" ","")))))
Result when I set flag3 to blank or N
Flag 1 Flag2 FALSE
I have also tried the IFERROR function as well and get the same result. =IFERROR(IF(B2="Y",B1&" "&IF(C2="Y",C1&" "&IF(D2="Y",D1&" "&IF(E2="Y",E1&" "&IF(F2="Y",F1&" ",""))))),"")
Please let me know if you have any ideas on how to bypass the false value and continue evaluating the if statements and combining the results.
Thanks
Bookmarks