How do I use VLOOKUP without considering minutes and seconds?

Occasional Visitor
1 Reply

@Dboobalan Use TRUE as the last argument in the formula. That will return the closest match that is not greater than the lookup value.

=VLOOKUP(A3,Sheet3!A:A,1,TRUE)