How to detect #N/A and return 0?

E

Eric

Does anyone know how to detect #N/A? if it finds, then return 0 value.
Does anyone have any suggestions/
Thank you in advance
Eric
 
J

JE McGimpsey

How is #N/A being generated?

If by a lookup, then:

=IF(ISNA(VLOOKUP(...),0,VLOOKUP(...))
 
Top