Try

=IF(ISNUMBER(MATCH(H7;Sheet1!$O$1:$O$7;0));INDEX(S heet1!$H$1:$H$7;MATCH(H7;Sheet1!$O$1:$O$7;0)))

--

HTH

Bob

"thommes" wrote in message
...
Hi all!

Sheet1 contains the following:
Col_H Col_O
302 33937
158 32840
3582 73345
39760 73455
4412 AGL92
2941 AHW92
136 30044

Sheet2 contains this:
Col_H
34132
34332
33532
31032
34433
34633
33937

This is the function I use along Col_I:
=IF(ISNA(VLOOKUP(H1;Sheet1!$H$1:$O
$7;1;FALSE))=TRUE;VLOOKUP(VALUE(H1);Sheet1!$H$1:$O
$7;1;FALSE);VLOOKUP(H1;Sheet!$H$1:$O$7;1;FALSE))

For H7 I would expect the function to return 302, but it only retuns
#N/A for all rows in Col_H.

I use concatenate to generate the data in Col_O in Sheet1. I also
tried to copy the values and do the vlookup inside the same sheet. But
still no result.

Please, advise!
WBR
Thommes