Hi,

VLOOKUP looks up the first column and returns a column to the right, It
can't work the other way around so try this

=IF(COUNTIF(Sheet1!$O$1:$O$7,H1)=0,"",INDEX(Sheet1 !$H$1:$H$7,MATCH(H1,Sheet1!$O$1:$O$7,0)))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"thommes" wrote:

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
.