want blank - not #N/A
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
|