Match

  • Thread starter Thread starter Bill Allen
  • Start date Start date
B

Bill Allen

If no result is found, how can I have this function return "0" instead of
"#N/A"?

Thanks,

Bill Allen
 
Bill Allen wrote...
If no result is found, how can I have this function return "0" instead of
"#N/A"?
Click to expand...

=IF(ISNA(MATCH(...)),0,MATCH(...))
 
Thanks, Harlan.

This is one of those "palm to the forehead" moments.

:o)

Regards,

Bill
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match function with time 3
Find 2 values & return row number 1
vlookup - can't find match 1
Searching a table of data using an array and returning the array's header?!? 4
VLookup Function HELP 7
matching entries by partial match 3
Formula not working - vlookup 1
match formula 2

Back
Top