+ Reply to Thread
Results 1 to 6 of 6

Find specific words in a list and populate the word found in column C

  1. #1
    Registered User
    Join Date
    06-18-2019
    Location
    Delaware
    MS-Off Ver
    365
    Posts
    2

    Find specific words in a list and populate the word found in column C

    I have a list of trigger words in column B and the list needs to be compared to the Comments column (column B). The only formula I am able to create gives me results of True, False or Yes, No. I am needing the formula to return the trigger word in column B. Help would be most appreciated. Thank you very much.

    Column A / Column B / Column C
    Comments / TriggerWords
    Foreclosure is not an option / debt
    My APR is too high / 60+
    Please forgive my debt / 90+
    My bills are late / accelerate
    Foreclosure is not an option / annual percentage rate
    My APR is too high/ annual percentage yield
    Please forgive my debt / APR
    My bills are late / APY
    Foreclosure is not an option / bonus
    My APR is too high / Foreclosure
    Please forgive my debt / cancel
    My bills are late / charge off
    Foreclosure is not an option / collection
    Attached Files Attached Files
    Last edited by catesgene; 06-18-2019 at 12:02 PM. Reason: Added Attachment

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Find specific words in a list and populate the word found in column C

    could you perhaps give some examples? You say that you have a list of trigger words in column B and compared to the comments in column B and from what you show it appears that "Foreclosure is not an option" is in cell A3 and "debt" is in B3? What is the expected outcome from your list in col A and list in col B? You have more than one instance of Foreclosure is not an option as well as My APR is too high as well as different items in col B across from those. What are your expected results?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Find specific words in a list and populate the word found in column C

    perhaps a sample workbook with EXPECTED result would help better? Click go advanced below the reply window, then mid way down click on manage attachments the browse upload Ok, Ok to upload a sample.

  4. #4
    Registered User
    Join Date
    06-18-2019
    Location
    Delaware
    MS-Off Ver
    365
    Posts
    2
    Quote Originally Posted by Sambo kid View Post
    could you perhaps give some examples? You say that you have a list of trigger words in column B and compared to the comments in column B and from what you show it appears that "Foreclosure is not an option" is in cell A3 and "debt" is in B3? What is the expected outcome from your list in col A and list in col B? You have more than one instance of Foreclosure is not an option as well as My APR is too high as well as different items in col B across from those. What are your expected results?
    Hello. Thank you for responding. I am most appreciative. I have attached a mock spreadsheet. Let me know if it makes sense. : )

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Find specific words in a list and populate the word found in column C

    this I found after testing it will work, BUT, you might run into issues if you have two of the items in your list in col I that are both in one of the items in col A.
    =LOOKUP("zzzzz",CHOOSE({1,2},"",LOOKUP(1E+100,SEARCH($I$2:$I$56,A2),$I$2:$I$56)))
    So, it returns the value "late fee" for A10 when Late Fees is noted in the comment.
    It returns "reinstate" instead of APR from cell A43 because it found reinstate first in the comment.

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Find specific words in a list and populate the word found in column C

    here is a shorter version but it still has the same returns as the formula I posted in comment #5... =IFERROR(LOOKUP(1E+100,SEARCH($I$2:$I$56,A2),$I$2:$I$56),"")

+ 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. Find / Extract Word & Words after a Specific Word
    By roseuz in forum Excel General
    Replies: 8
    Last Post: 07-05-2017, 01:07 PM
  2. [SOLVED] Find whole word in a cell from a list of words
    By SperoTsindos in forum Excel General
    Replies: 10
    Last Post: 04-21-2017, 12:28 AM
  3. [SOLVED] Formula - If find 3 possible words within a cell, return the word found?
    By nobodyukno in forum Excel General
    Replies: 4
    Last Post: 03-17-2017, 01:30 PM
  4. Replies: 1
    Last Post: 02-21-2016, 02:39 AM
  5. [SOLVED] looking to find 1 of 2 words in a cell in column B and return the word found in the same
    By Rob69mfj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2014, 01:17 PM
  6. Using "Find" to return results if a word is found within multiple words in a cell
    By pylauzier in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2011, 01:37 PM
  7. fastest way to find the row where a specific text is found in a specific column
    By getgray in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2011, 02:45 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