I currently have a look-up that evaluates Column AI. When Column A has a specific value, Column DI is outputting a specific value. If Column A is blank, a “N/A” is output in Column DI. That is working correctly.
Current formula:
=IFERROR(VLOOKUP(AI2,Sheet1!N:O,2,FALSE),"N/A")
However, I need to evaluate two other columns as part of the formula. Some of the values that have a value of “N/A” can be more accurate if I evaluate two other columns.
How would I update the existing formula to evaluate the other two columns?'
If Column AI = blank then
If Column AG2 = “Hello” OR Column AH2 = “Hello1” or Column AH2 = “Hello2” then output a value of “Greeting”
ELSE
If Column AG2 = “Bye” OR Column AH2 = “Bye1” or Column AH2 = “Bye2” then output a value of “Later”
ELSE
Evaluate the current formula.
Bookmarks