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

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

=IF(ISNA(MATCH(D12,'Holiday Date'!$A$1:$A$8,0),"",MATCH(D12,'Holiday
Date'!$A$1:$A$8,0))
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"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

THANK YOU
Works like a charm!



Anne Troy wrote:

=IF(ISNA(MATCH(D12,'Holiday Date'!$A$1:$A$8,0),"",MATCH(D12,'Holiday
Date'!$A$1:$A$8,0))
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"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