LinkBack URL
About LinkBacks
Example :
MATCH(TRUE,ISNUMBER(SEARCH(C2,$A$1:$A$5)),0) - no match thus appear #NA
How to make #NA to blank column?
Example :
MATCH(TRUE,ISNUMBER(SEARCH(C2,$A$1:$A$5)),0) - no match thus appear #NA
How to make #NA to blank column?
Last edited by Shermaine2010; 09-29-2011 at 05:39 AM.
You can try putting an "if" formula. If the cell contains #N/A, then "", otherwise the formula.
This might work:Originally Posted by Shermaine2010
=IF(ISNA(MATCH(TRUE,ISNUMBER(SEARCH(C2,$A$1:$A$5)),0)),"",MATCH(TRUE,ISNUMBER(SEARCH(C2,$A$1:$A$5)),0))
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Hi,
A blank cell appears when "c2" is not found in "A1:A5", but a blank cell appears even when c2 is found in a1:a5. A bit confusing. Could someone explain?
Use this formula:
Do not just press "Enter" but Press "Ctrl" + "Shift" + "Enter"=IF(ISNA(MATCH(TRUE,ISNUMBER(SEARCH(C2,$A$1:$A$5)),0)),"",MATCH(TRUE,ISNUMBER(SEARCH(C2,$A$1:$A$5)),0))
Here's a non-array formula that might do the same trick.
Hope this helps.
Please Login or Register to view this content.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Hi Abousetta,
I must admit that I would also prefer your non-Array formula, but that would depend on the what the situation warrants. i.e. Array Formula shows 1 if C2 And A1:A5 were to be empty, whilts non-array formula shows nothing at all.
Everything in life depends on so many variables. Some are volatile and others constant... (most are volatile)...
abousetta
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks