View Single Post
  #1   Report Post  
SalientAnimal SalientAnimal is offline
Junior Member
 
Posts: 19
Exclamation 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".