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

Thread view:

Thread rating:

Chase - 20 Oct 2005 20:06 GMT

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

Thanks

Vacation's Over - 20 Oct 2005 20:16 GMT

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

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

Alan - 20 Oct 2005 20:20 GMT

=IF(ISNA(VLOOKUP(A1,C1:D100,2,FALSE)),0,VLOOKUP(A1,C1:D100,2,FALSE))
Regards,
Alan.

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

mbpoet - 16 May 2008 20:06 GMT

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

Gaurav - 16 May 2008 21:10 GMT

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

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