From: Bob Phillips on
Thommes,

I recreated the data as you laid out, and the first 6 gave me FALSE as yours
did, but I got 302 for the 7th as that is the only one matching.

I am not sure what all of those extra bits in your latest post mean.

--

HTH

Bob

"thommes" <thommes(a)c2i.net> wrote in message
news:ce578891-4975-48e8-96ea-f61a2efb4c23(a)u31g2000yqb.googlegroups.com...
On 2 Apr., 11:37, "Bob Phillips" <bob.phill...(a)somewhere.com> wrote:
> Try
>
> =IF(ISNUMBER(MATCH(H7;Sheet1!$O$1:$O$7;0));INDEX(Sheet1!$H$1:$H$7;MATCH(H7;�Sheet1!$O$1:$O$7;0)))
>
> --
>
> HTH
>
> Bob
>

Hi Bob!

Thank you. I tried it but it didn't work. Here is what I did:

302 33937 33937 #N/A FALSE
158 32840 32840 #N/A FALSE
3582 73345 73345 #N/A FALSE
39760 73455 73455 #N/A FALSE
4412 AGL92 AGL92 #VALUE! FALSE
2941 AHW92 AHW92 #VALUE! FALSE
136 30044 30044 #N/A FALSE

Cols A, B, E, F, G
In G I have your function: =IF(ISNUMBER(MATCH(E1;$A$1:$B$7;0));INDEX($A
$1:$B$7;MATCH(E1;$A$1:$B$7;0)))
which gives FALSE.

Any other ideas?

Best regards
Thommes


From: thommes on
Hi again!

It all works perfectly well.

This is the function I used:
=IF(ISNA(VLOOKUP(H2;CYBEX_Bestand!$O$10:$P
$11392;2;FALSE))=TRUE;VLOOKUP(VALUE(H2);CYBEX_Bestand!$O$10:$P
$11392;2;FALSE);VLOOKUP(H2;CYBEX_Bestand!$O$10:$P$11392;2;FALSE))

I copied the columns with the check values to the right according to
what Mike said:
"VLOOKUP looks up the first column and returns a column to the right,
It
can't work the other way around [...]"

Thanks to both of you, Bob and Mike!

Best regards

Thommes