LucidCheetah
New Member
- Joined
- Dec 11, 2017
- Messages
- 15
I have the following string checking another sheet to see if an input value exists, when the value exists based on the vlookup, I have it display and "Open" text. I would also like to highlight that cell with a yellow background. Is this doable? I don't quite understand the nesting of different functions.
Code:
=IF(ISNA(VLOOKUP(C2,'Orders'!$A$1:$B$2662,2,FALSE)),"","OPEN")