Hi Team,
So I have Restaurant locations in column B a table in column I and an action item in column E.
At the moment, if any cell in column B matches the table in column I, it highlights red.
The formula for that works perfectly and is as follows:
=NOT(ISNA(VLOOKUP(B1,$I$22:$I$31,1,FALSE)))
Now I would like the above formula to factor in column E as mentioned previously to do ONE of the following:
1) To do the formula above IF column E value = "911" or "Escalation"
2) To STOP the formula above IF column E value = "Non-Escalation"
Please let me know if you have any further questions! Thank you!
Bookmarks