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!
==============================================


"sunflower" wrote in message
...
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