Page 5 of 5 FirstFirst ... 345
Results 41 to 45 of 45

Thread: Search for multiple text strings simultaneously in a single cell
Thanks Thanks: 0 Likes Likes: 0

  1. #41
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,078
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Search for multiple text strings simultaneously in a single cell

    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.
    Assuming too much and qualifying too much are two faces of the same problem.

  2. #42
    New Member
    Join Date
    May 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Search for multiple text strings simultaneously in a single cell

    Quote Originally Posted by Aladin Akyurek View Post
    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!

  3. #43
    New Member
    Join Date
    May 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Search for multiple text strings simultaneously in a single cell

    Quote Originally Posted by imhbk View Post
    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!

  4. #44
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    15,905
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Search for multiple text strings simultaneously in a single cell

    Quote Originally Posted by imhbk View Post
    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 by Marcelo Branco; May 18th, 2019 at 03:14 PM.

  5. #45
    New Member
    Join Date
    May 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Search for multiple text strings simultaneously in a single cell

    Quote Originally Posted by Marcelo Branco View Post
    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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •