vlookup's value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
=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
 
Back
Top