Thread: Can I turn the #N/A result from a lookup function to a zero?
View Single Post
  #2   Report Post  
Vacation's Over
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote