How Can I: Search a Collumn in Other Document for Partial Text?
In my sheet I need to know if the contents of AF13 are present in column R of a different document.
The challenge for me is that the cells in column R are of mixed content, so the search must not require an exact match.
This is the formula that works in exact match conditions:
=IF(ISERROR(MATCH(AF13,'[document.xlsm]sheet'!$R:$R,0)),"No","Yes")
Can anyone help out with this, please?
If the value in AF13 is the base that you want to look for (for example, if R:R might contain "new system", "new computer", "another new system", etc. , and AF13 contains "new") then
=IF(ISERROR(MATCH("*"&AF13&"*",'[document.xlsm]sheet'!$R:$R,0)),"No","Yes")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
OMG SO SIMPLE! Thanks, that's the ticket!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks