Vlookup Question About Date With Time

[rkrieg]

I want to do a vlookup and find anything from the date 10/13/10, but the actual hour is included in the data row. Is there a way to do the vlookup only to the date and not include the time...something without additional steps ie text to column or something like that.

10/13/10 23:55
10/13/10 23:53
10/13/10 23:50
10/13/10 23:48
10/13/10 23:44
10/13/10 23:43
10/13/10 23:43
10/13/10 23:42

[daddylonglegs]

Try using INDEX and MATCH like this

=INDEX(B2:B20,MATCH(C2,INDEX(INT(A2:A20),0),0))

where C2 is the date to lookup, A2:A20 contains dates/times and B2:B20 is the column from which you want a value returned