Thread: MATCH and #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill Bill is offline
external usenet poster
  
Posts: 390
Default MATCH and #N/A
I am searching 12 columns to find the occurance of a particular letter. If
the letter is not in any of the columns, MATCH returns #N/A. How do I set up
the formula to return zero instead of #N/A?
Reply With QuoteReply With Quote