how do I replace #n/a in a formula with 0, without erasing my for.

C

ChiragP

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
 
F

Frank Kabel

Hi
1. Option:
change your lookup formula to something like
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(..))

2. Option
use the following formule (e.g. vLOOKUP formula is in cell C1):
=IF(ISNA(C1),0,C1*2)
 
C

ChiragP

Thanks Frank

Frank Kabel said:
Hi
1. Option:
change your lookup formula to something like
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(..))

2. Option
use the following formule (e.g. vLOOKUP formula is in cell C1):
=IF(ISNA(C1),0,C1*2)
Click to expand...
 
M

microsoft.public.excel.misc

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