Results 1 to 12 of 12

Match words from a list with strings in a excel column

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2014
    Location
    NJ, USA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Match words from a list with strings in a excel column

    Hello, I searched the forum and there are a few threads addressing this question but not sure if it works for me.
    See attached. I have 2 sheets - one with the data and one with matching words.
    I would like to match the words from 'List' sheet with col1 in 'Data' sheet. If an exact match is found anywhere in the string I would like the word from the list be populated in col2 of data sheet.
    I have also used formulas I gathered from the forum in formula columns in data sheet.
    Would appreciate your input.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 04-29-2013, 03:13 PM
  2. [SOLVED] Coloring certain words in strings based on list....?
    By Flabbergaster in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-30-2012, 09:30 AM
  3. Replies: 1
    Last Post: 04-04-2012, 07:15 PM
  4. MATCH *similar* strings and return adjacent column value
    By mzerega in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2009, 07:36 PM
  5. Extracting strings from a column of data that match a predefined list
    By jmurray in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-16-2009, 05:10 AM

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