Dear All,
please have a look at the attached workbook.
I want to compare column E on Sheet 1 with entries in Sheet 2.
If the entry is part of something in E, it should then mark the entire row with an "o" in Column A
I came up withFormula:
Please Login or Register to view this content.
but this only marks it if the entire cell is a match.
Thank you !!
Last edited by elgato74; 12-05-2017 at 03:10 PM.
Try this in A1:
=IF(SUMPRODUCT(ISNUMBER(SEARCH(Sheet2!A$1:A$31,E1))*ROW(Sheet2!A$1:A$31)),"x","")
Thank you !! So fast and easy
You're welcome. Thanks for the rep!
Here is another one
Formula:Please Login or Register to view this content.
Last edited by AlKey; 12-05-2017 at 03:51 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks