VLOOKUP and matching TIME

  • Thread starter Thread starter mluetkem
  • Start date Start date
M

mluetkem

How do you search a table based on TIME, it seems to not like the forma
I have time in. I'm using VLOOKUP(D2, A2:B6, 2, FALSE) where D2 i
time in the format hh:mm AM/PM and likewise col A is in the sam
format.

Mik
 
Be sure where you have the formula to format it the same as column D an
A ..because it worked with me
 
Hi
what error did you get?. You may try the following if you have a match
in column A
=D2=A3
if A3 should match D2. This should return TRUE. If not there may be
formating issues
 
It seems to work OK for me. I noticed you have FALSE as
your range lookup criteria. With this setting, if the
time value you enter in cell D2 is not listed in Column
A, you'll get a #NA error. If you change this setting to
TRUE, and the value in cell D2 is not contained in Column
A, the formula will look up the largest value in Column A
that is less than the value in D2. Your lookup table must
be sorted in ascending order if you use TRUE.

Original Message-----
 
Back
Top