try this:
IF(ISNA(VLOOKUP($B15,$J$14:$N$60,2,FALSE)),0,VLOOKUP($B15,$J$14:$N$60,2,FALSE))

"Lillian Eik" wrote:

>
> 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
>
>