#num

[Pammy]

I have a formula to give a 0 instead of an error. Some of the calculations
give me a #num instead of a 0, . Is there something I could add to the
formula below to either give a 0 or blank but no #num.


IF(ISNA(VLOOKUP(Y192,longv,2,FALSE)),0,VLOOKUP(Y192,longv,2,FALSE))

 

[Michael]

Use iserror instead of ISNA
IF(ISERROR(VLOOKUP(Y192,longv,2,FALSE)),0,VLOOKUP(Y192,longv,2,FALSE))

 

[porter444]

Try this instead:

=IF(ISERROR(VLOOKUP(Y192,longv,2,FALSE),"0",VLOOKUP(Y192,longv,2,FALSE)

 

[Per Jessen]

Hi

Try to substitute "ISNA" with "ISERROR"

Regards,
Per