vlookup's value

M

monker

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
 
D

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
 
Top