=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2; Internal!B:C;2;FALSE);0)

would be one way where 0 would be returned if there is no match, if you want
what looks like an empty cell

=IF(ISNUMBER(MATCH(B2;Internal!B:B;0));VLOOKUP(B2; Internal!B:C;2;FALSE);"")


--
Regards,

Peo Sjoblom

(No private emails please)


"Lillian Eik"
wrote in message
...

Hi!

If anybody know a way around this I'll be forever thankfull.

I have a standard list which uses vlookup to another list which varies.
If there is not a match I get #N/A and that messes up my subtotals in
the first list. I have tried variations with if, match and find but I
can not make it work.

N2=VLOOKUP(B2;Internal!B:C;2;FALSE)
N2=FD312 Insurance

Thanks in advance


--
Lillian Eik
------------------------------------------------------------------------
Lillian Eik's Profile:
http://www.excelforum.com/member.php...o&userid=24919
View this thread: http://www.excelforum.com/showthread...hreadid=384575