vlookup returns na
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
|