Can I turn the #N/A result from a lookup function to a zero?

Chase · Oct 20, 2005

Can I turn the #N/A result from a lookup function to a zero?

Thanks

Vacation's Over · Oct 20, 2005

= if(isError( 'yourlookupcodehere) , 0 , 'yourlookupcodehere)

Alan · Oct 20, 2005

=IF(ISNA(VLOOKUP(A1,C1

100,2,FALSE)),0,VLOOKUP(A1,C1

100,2,FALSE))
Regards,
Alan.

mbpoet · May 16, 2008

Chase said:
Can I turn the #N/A result from a lookup function to a zero?

Thanks

Gaurav · May 16, 2008

=IF(ISNA(your formula),0,your formula)