Hi, everyone,
I have 5 keywords in cells A1:A5,
Quarter
Semi
Final
Regular
Interim
Now I want to test if cell B1 contains one of the 5 keywords. Cell B1 is a text which is something like FinalABC. Because FinalABC contains the keyword Final, it should return true.
Is it possible to test this in Excel? Otherwise, I have to do this in VBA.
This will find the matching word:
=LOOKUP(2,1/ISNUMBER(SEARCH(A1:A5,B1)),A1:A5)
But if you only need yes/no:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH(A1:A5,B1))),"Yes","No")
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Many thanks, daffodil11. It worked nicely
No problem, glad I could help.
If the Cell B1 contains multiple keywords, how to use the formula to extract multiple keywords
To extract multiple keywords:
If you are using Excel 2021 or newer in the meantime please try:Formula:
Please Login or Register to view this content.
Last edited by HansDouwe; 02-22-2024 at 01:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks