want blank - not #N/A

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
 
R

RagDyeR

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
 
Top