vlookup's value

[Guest]

HI, Please help

I use vlookup, but it return a "#N/A", please show me how to make it be zero, because I
want to use it to plus a cell

Thanks in advance
Monke

 

[DNF Karran]

=IF(ISNA(VLOOKUP(B2,A2,1,FALSE)),0,VLOOKUP(B2,A2,1,FALSE))

You have to do this as the VLOOKUP errors so to get "0" when it error
you have to trap it with an IF statement

Dunca