vlookup help - urgent

[sharmashanu]

Hi all
I am trying to find a value in column 1 of table A, that is similar to
value in column 1 of table B.
I tried using VLOOKUP function( =vlookup(A1, B1:B20, true) but it is
giving me repeated values.
.. Consider the following


A- col1 B-Col1 Result

5:39 AM 5:45 AM 5:39 AM
5:47 AM 5:50 AM 5:47 AM repeat
5:55 AM 5:55 AM 5:47 AM repeat
6:02 AM 6:00 AM 5:55 AM
6:09 AM 6:05 AM 6:02 AM
6:15 AM 6:10 AM 6:09 AM repeat
6:21 AM 6:15 AM 6:09 AM repeat
6:27 AM 6:20 AM 6:15 AM
6:33 AM 6:25 AM 6:21 AM
6:39 AM 6:30 AM 6:27 AM
6:44 AM 6:35 AM 6:33 AM
6:49 AM 6:40 AM 6:39 AM
6:54 AM 6:45 AM 6:44 AM
6:59 AM 6:50 AM 6:49 AM
7:04 AM 6:55 AM 6:54 AM
7:08 AM 7:00 AM 6:59 AM
7:13 AM 7:05 AM 7:04 AM
7:17 AM 7:10 AM 7:08 AM
7:21 AM 7:15 AM 7:13 AM

Is it possible to remove the repeated value and consider the next
higher value.
Function or macro any help is appreciated.

 

[Guest]

Please try:
=VLOOKUP(A6, B$5:B$23, 1,TRUE)

the look up range remains constant and the value returned is from column B.
5:39 is less than 5:45 so a N/A value is returned as explained in help on
this function.