+ Reply to Thread
Results 1 to 6 of 6

Find keyword in a string of words in cell and match with text from list

  1. #1
    Forum Contributor
    Join Date
    03-27-2022
    Location
    MS, USA
    MS-Off Ver
    Microsoft 365
    Posts
    143

    Find keyword in a string of words in cell and match with text from list

    I am seeking to search through a cell in (B3) for a keyword in a sentence. The keyword should match a word a list in column H (H3:H6). I want the keyword from column H to appear in column F(F3). Any help would be appreciated, thank you in advance. I would post the workbook for reference, but right now the forum isn't allowing me to upload.

    B3 cell value
    I want green eggs and ham

    H3:H6 List
    Green
    Blue
    Red
    Black
    Last edited by Ajaxs87; 07-27-2022 at 09:55 PM.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2021
    Posts
    5,931

    Re: Find keyword in a string of words in cell and match with text from list

    Try this

    =LOOKUP(1,-SEARCH($H$3:$H$6,B3),$H$3:$H$6)

  3. #3
    Registered User
    Join Date
    07-22-2022
    Location
    Surabaya, Indonesia
    MS-Off Ver
    365
    Posts
    14

    Re: Find keyword in a string of words in cell and match with text from list

    Alternate using INDEX MATCH
    =INDEX($H$3:$H$6,MATCH(TRUE,ISNUMBER(SEARCH($H$3:$H$6,B3,1)),0))
    Best Regards,
    solusipembukuan.com
    +6287878935858

  4. #4
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,861

    Re: Find keyword in a string of words in cell and match with text from list

    Another option (that will show multiple matches if there are any)

    =FILTER(H3:H6,ISNUMBER(SEARCH(H3:H6,B3)))

  5. #5
    Forum Contributor
    Join Date
    03-27-2022
    Location
    MS, USA
    MS-Off Ver
    Microsoft 365
    Posts
    143

    Re: Find keyword in a string of words in cell and match with text from list

    Thank you for your help, these worked. I will do more research on the formulas suggested to improve my knowledge.

  6. #6
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,861

    Re: Find keyword in a string of words in cell and match with text from list

    You're welcome and thanks for the feedback and rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find matching words in a text string and return one of four words
    By alecoute in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2018, 12:33 PM
  2. Find, List and Count All Words within a Text String
    By TheDrMrsSmith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2014, 11:07 PM
  3. [SOLVED] Find text string exist in cell from keys words
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-11-2013, 01:56 AM
  4. [SOLVED] Need to chck if a keyword is present in a text string and return keyword if yes
    By Jekaterina in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-16-2012, 05:55 PM
  5. how to write macro to find and match common string and write the keyword
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2012, 07:41 AM
  6. Replies: 0
    Last Post: 07-11-2012, 06:05 AM
  7. Replies: 1
    Last Post: 04-04-2012, 07:15 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1