vlookup help

[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.

 

[mithu]

try =vlookup(a1,b1:b20,1,false)

 

[sharmashanu]

hi mithu
if i try ur idea then i will not get any value for most of rows. I
must have a value from Col A , that is close to the value in col B and
it should not be repeated one picked from col A.

 

[Divy]

hi mithu
if i try ur idea then i will not get any value for most of rows. I
must have a value from Col A , that is close to the value in col B and
it should not be repeated one picked from col A.

Hi buddy....

have you tried this: -

=IF(ISERROR(VLOOKUP(A39,$B$39:$B$57,1,0)),"-",(VLOOKUP(A39,$B$39:$B
$57,1,0)))

is this working....