Hello "Smarter People Than I" ...
After 2 hours of searching for an answer to this, I give up. Can you please help with this question? (I thought it would be fairly simple to find but I was wrong!)
I have five (5) cells in a row. Only one (1) will have an "X" in it. Based on which cell (column) it is found in, I need to return a value from a list of values.
For example, if the "X" is in cell A2, return "Blue"; if it's in B2 return "Green"; if it's in C2 return "Brown"; if it's in D2 return "Black"; if it's in E2 return "Orange."
I thought of nested IF statements but that seems much more complicated then necessary?
Any help or direction will be greatly appreciated.
Thank you!!!
Bookmarks