View Single Post
  #1   Report Post  
sunflower
 
Posts: n/a
Default 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