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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can I turn the #N/A result from a lookup function to a zero? (https://www.excelbanter.com/excel-worksheet-functions/51517-can-i-turn-n-result-lookup-function-zero.html)

Chase

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

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

Thanks

Vacation's Over

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

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

"Chase" wrote:

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

Thanks

Alan

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

=IF(ISNA(VLOOKUP(A1,C1:D100,2,FALSE)),0,VLOOKUP(A1 ,C1:D100,2,FALSE))
Regards,
Alan.
"Chase" wrote in message
...
Can I turn the #N/A result from a lookup function to a zero?

Thanks

mbpoet

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

"Chase" wrote:

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

Thanks

Gaurav[_3_]

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

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

"mbpoet" wrote in message
...

"Chase" wrote:

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

Thanks

All times are GMT +1. The time now is 11:21 PM.