Hello gurus,
I was hoping that someone could help me with a formula. I searched for similar issues but am unable to make the solutions work to my advantage.
Please see attached workbook if it helps. I need to combine the answers given in A2: A6 (dropdowns), and put the corresponding text for that answer into cells E4-E6 respectively.
In effect summarizing what I liked best, middle and least. I can’t figure out t the nested formula that I will need.
I’s appreciate some insight if you can share it.
Hello gurus.jpg
Thanks,
Daniel
Bookmarks