pls. type =if(iserror(vlookup(it's range)),0,vlookup(repeat vlookup formula)



"ChiragP" wrote:

I have a vlookup formula which sometimes gives the result #n/a ( due to the
result not being in the vlookup table ). However, I have another formula
which looks at this result and if this result is #n/a then it also gives me
the result #n/a.

Does anyone know how I can amend this so the second formula recognises the
#n/a as a 0 ????

The problem I have is that I need to keep all the formulas