VLOOKUP With Multiple Criteria
Hi All.
I need to create a formula to evalute the value returned by the VLOOKUP. When the VLOOKUP makes a match if needs to check if the value of the returned value is:
Criteria 1
Between 06:00:00 and 06:30:00
Criteria 2
08:00:00 and 08:30:00
Criteria 3
09:00:00
Should the evaluated value fall between one of the specified value it needs to return a value of "Yes". If however the value falls outside the three mentioned criteria it needs to return a value of "No".
|