+ Reply to Thread
Results 1 to 3 of 3

How to search a column for a list of 20 different names

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    North Carolina USA
    MS-Off Ver
    MS Office 2016
    Posts
    368

    How to search a column for a list of 20 different names

    Hi, I have got a list of search strings, lets say Search String 1, Search String 2, Search String 3, etc.

    and I need to look for each for each search string in column a, and if found, return that search string name in column b

    Attached is an example -- Sheet2 has 20 search strings I am looking for

    Sheet1 - Column A has the data I need to search in (i only included 5 examples -- i think thats enough for you guys to get the idea)

    Sheet1 - Column B shows my desired output

    What formula, or vba can I use to do this? (Note: The column will contain around 2,000 items to search (column A in this example) and there will be around 30 search strings that I am looking for)


    Thanks for your help!
    Attached Files Attached Files
    Last edited by BG1983; 01-06-2017 at 01:34 PM.

  2. #2
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    206

    Re: How to search a column for a list of 20 different names

    example.xlsm

    this example you can use

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: How to search a column for a list of 20 different names

    Try this sheet:
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Search for file names and list them in column A
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-24-2016, 01:52 AM
  2. Replies: 2
    Last Post: 12-08-2015, 03:01 PM
  3. Replies: 1
    Last Post: 09-25-2015, 02:14 PM
  4. [SOLVED] Search and list multiple names
    By ANDREAAS in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-05-2015, 11:34 PM
  5. Search a range Last Names for age & return the value to a List of FULL NAMES
    By LunarLights in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-16-2014, 05:02 PM
  6. [SOLVED] Search a list of names and automatically return any names not already included in table
    By bishbash89 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-21-2013, 09:06 AM
  7. Replies: 2
    Last Post: 10-08-2012, 12:49 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