Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
blank cell turns to 0 | New Users to Excel | |||
blank cells | Excel Discussion (Misc queries) | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions |