Forum Discussion
Solved
How To Use VLOOKUP Using Date, To Find Corresponding Holiday With Additional Criteria
I am looking for a way to do the following: display a checkmark box (using the corresponding cell reference in Sheet2) if the day is a holiday. 1. Use a given date in Sheet1 2. Go to Sheet2 and l...
See the attached version. I created a conditional formatting rule of type 'Use a formula to determine which cells to format' with formula
=$B5=VLOOKUP($H$2,Sheet2!$D$3:$E$11,2,FALSE)
See the attached version. I created a conditional formatting rule of type 'Use a formula to determine which cells to format' with formula
=$B5=VLOOKUP($H$2,Sheet2!$D$3:$E$11,2,FALSE)
Thanks so much! I didn't know you could use 2 equal signs like you've done!
Thank you, again!
Thank you, again!
The first = starts the formula.
The second = is used to compare the cell value with the result of VLOOKUP. If they are equal, the formula returns TRUE, otherwise FALSE.