cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How do I use VLOOKUP without considering minutes and seconds?

Dboobalan
Copper Contributor

‎Jan 14 2022 10:58 PM

‎Jan 14 2022 10:58 PM

How do I use VLOOKUP without considering minutes and seconds?

  1. CC_Express_20220115_1111020.03238884528439778.png
Labels:
685 Views
0 Likes
1 Reply
Reply
1 Reply
Riny_van_Eekelen

‎Jan 14 2022 11:13 PM

‎Jan 14 2022 11:13 PM

Re: How do I use VLOOKUP without considering minutes and seconds?

@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)

 

0 Likes
Reply