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" wrote in message
...
On 2 Apr., 11:37, "Bob Phillips" wrote:
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


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