+ Reply to Thread
Results 1 to 3 of 3

Return True/False if a string of words is present in another list

  1. #1
    Registered User
    Join Date
    12-05-2013
    Location
    Boston
    MS-Off Ver
    Excel 2003=7
    Posts
    2

    Return True/False if a string of words is present in another list

    Hi,

    I have two lists, one that is 99,000 lines and the other is 150. I am trying to find out where the word(s) in the list of 150 is present in the list 99,000.

    1st list of 99,000 is in Sheet1 A1-A99000 and the second list is in Sheet2 B1-B150.

    The caveat is that in column A there is additional words in that cell so you can not do a simple vlookup, because there may or may not be an exact match.

    I have been stuck for hours and the best i can get is to use the match function but it is not working because it is not exact. Last thing i want to do is use the CTRL F key to lookup all the words.

    Thank you,
    Tim

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Return True/False if a string of words is present in another list

    You can use wildcard characters with VLOOKUP and with MATCH (and also with COUNTIF, which is another possible approach), so can you tell us how you want to indicate if one or more of the words in Sheet2 is in column A of Sheet1 - a yes/no answer in column B of Sheet1 ?

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    12-05-2013
    Location
    Boston
    MS-Off Ver
    Excel 2003=7
    Posts
    2

    Re: Return True/False if a string of words is present in another list

    Quote Originally Posted by Pete_UK View Post
    You can use wildcard characters with VLOOKUP and with MATCH (and also with COUNTIF, which is another possible approach), so can you tell us how you want to indicate if one or more of the words in Sheet2 is in column A of Sheet1 - a yes/no answer in column B of Sheet1 ?

    Hope this helps.

    Pete
    Thanks Pete, did not realize you can use wildcards for vlookups thats something I will look into. Fortunately, I had a co-worker through it in SQL server and did something similar to get the results. Thank you for the timely response. Cheers - Tim

+ 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] Return True/False by searching a value in an array of string
    By aiyathomas in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-30-2013, 12:35 PM
  2. [SOLVED] Match specific words in cell and return value if true or false
    By jbrooksia in forum Excel General
    Replies: 3
    Last Post: 03-27-2012, 04:15 PM
  3. Replies: 6
    Last Post: 10-06-2011, 12:32 AM
  4. Replies: 2
    Last Post: 02-17-2011, 10:15 PM
  5. Replies: 3
    Last Post: 03-12-2010, 02:57 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