Displaying #N/A as a zero

K

kosciosco

When I use a lookup formula in certain circumstance it returns a #N/A.

How can I show this as a zero so that I can sort on this?

Thanks

Simo
 
F

Frank Kabel

Hi
i would make this
IF(ISNA(VLOOKUP(.......)),0,VLOOKUP(.......))

as other wise the zero is stored as 'Text' and not as numeric value
 
Top