Search for multiple text strings simultaneously in a single cell

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,170
Create a range housing the relevant search words like STUK, STUS, etc.. sort this range in ascending order, and name the range in question WordList via the Name Box.

Now, in B2 enter and copy down:

=LOOKUP(9.99999999999999E+307,SEARCH(" "&WordList&" "," "&A2&" "),WordList)

where A2 contains an email subject.
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

imhbk

New Member
Joined
May 16, 2019
Messages
5
Try...

=LOOKUP(9.99999999999999E+307,SEARCH(KeywordTable,E2),KeywordTable)
Thanks a lot....This is working fine.
is there any way do this same with VBA

I need to apply this in 2 columns (Column A, Column B) with 2 different keywordsTable (1, 2) respectively
column A will work with Keywordtable 1 and column B will work with keywordtable 2
and then return the keyword which found

Thanks for your help!
 

imhbk

New Member
Joined
May 16, 2019
Messages
5
Thanks a lot....This is working fine.
is there any way do this same with VBA

I need to apply this in 2 columns (Column A, Column B) with 2 different keywordsTable (1, 2) respectively
column A will work with Keywordtable 1 and column B will work with keywordtable 2
and then return the keyword which found

Thanks for your help!
Hi Team,

I really need solution for this. Appreciate your help. Thanks!
 

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
Hi Team,

I really need solution for this. Appreciate your help. Thanks!

This topic is getting too long and you are asking for a solution with VBA. Better create a new Thread by providing an example - data along with before/after macro.

M.
 
Last edited:

imhbk

New Member
Joined
May 16, 2019
Messages
5
This topic is getting too long and you are asking for a solution with VBA. Better create a new Thread by providing an example - data along with before/after macro.

M.
Thanks Marcelo. I created a new thread for this. looking for help :confused:
 

Watch MrExcel Video

Forum statistics

Threads
1,096,282
Messages
5,449,444
Members
405,566
Latest member
Simonpyman

This Week's Hot Topics

Top