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