Forum Discussion
IF Statement with multiple answers
Hi Linda,
Could you please attach small sample file with your data and desired calculations return, where and what it shall be (without any formulas)
sorry I wasn't sure where i needed to reply, so reply here as well.
My issue is that my IF statement is only picking up the first answer, but I need to have it pick up multiple answers. In this case both that are highlighted in yellow, per the IF statement written. You will see what I am doing when you look at the formula.
Hi Linda,
Thank you for the file. Formula could be
=INDEX($G$14:$G$17,MATCH(1,$B$14:$B$17,0)) & " " & INDEX($G$20:$G$23,MATCH(1,$B$20:$B$23,0)) & " " & INDEX($G$8:$G$11,MATCH(1,$B$8:$B$11,0))
it's in D24 of the attached file. No error handling assuming you always 1, but that easily could be added.
More important assumption you have only one 1 in each block of B cells, otherwise formula doesn't work and we need another one.
I actually see that you used a range in column B. I actually need it to be just one line, as each line has a different response that goes into a different location on the form. How would this look like based upon how I did the IF statements?
