I am attempting to create a formula to check data in a cell.
Because the IF function has limitations, I assume there's a better way to do this.
I have a column with cells filled with one of 16 names. I need a formula to check the name, then display one of 8 values.
So, for example if Column A says Red or Green, I want the formula to display the text "Christmas" in the cell adjacent in Column B.
Advice would be highly appreciated. I just need the proper function to use and the parameters.
Thank you.
Bookmarks