want blank - not #N/A

  • Thread starter Thread starter sunflower
  • Start date Start date
S

sunflower

Newbie needs Help Please

I have the following formula
=MATCH(D12,'Holiday Date'!$A$1:$A$8,0)

which works if there is a match,
When there is not a match, I get #N/A
I would like the cell to be blank when no match is found

any help much appreciated
 
Try this:

=IF(ISNA(MATCH(D12,'Holiday Date'!$A$1:$A$8,0)),"",MATCH(D12,'Holiday
Date'!$A$1:$A$8,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Newbie needs Help Please

I have the following formula
=MATCH(D12,'Holiday Date'!$A$1:$A$8,0)

which works if there is a match,
When there is not a match, I get #N/A
I would like the cell to be blank when no match is found

any help much appreciated
 
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

Comparison of columns using Conditional Formatting 3
Don't Display #N/A 1
#N/A help please 2
match formula 2
Vlookups to return a N/A value 3
Correct #N/A Value 6
Easier Match/Offset? 12
Add if blank statement to index match 6

Back
Top