Thread: how to put 0 instead of #n/a
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vas Vas is offline
external usenet poster
  
Posts: 6
Default how to put 0 instead of #n/a
I am putting Lookup function.suppose if value is not there in table array.
it is giving #N/A. I want 0 instead of #N/A. How ? Pleae help me.

Regd.

Vas
Reply With QuoteReply With Quote