+ Reply to Thread
Results 1 to 3 of 3

Identifying and reporting text in a string

  1. #1
    Registered User
    Join Date
    03-14-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Identifying and reporting text in a string

    Hello,

    First, I apologize if this has been answered already. I did some searching and had no luck finding a solution.

    Here's what I'm looking to do: I have a long list of text strings, and i'm looking to identify certain keywords, and report back those keywords.

    EXAMPLE:
    Column A is full of product descriptions:

    Black Otterbox Case for iPhone
    Blue Speck case for iphone
    Pink Otterbox case for GS3
    White Case Mate case for iphone 5
    Blue Otterbox case for iphone 4s

    Column B are the "brands" i'm searching for:
    OtterBox
    Case Mate
    Speck

    I would like to have a formula that searches for words in Column B located in Column A, then report back that word.

    Example, if A1 was "Black Otterbox case for iPhone", i would want the result in column c to read "OtterBox"

    Make sense? Thanks in advance for any help you can provide!!

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Identifying and reporting text in a string

    Try

    =LOOKUP(2^15,SEARCH($B$2:$B$4,A2),$B$2:$B$4)


    B2:B4 is your list of brands, A2 is the string to search for the brands.

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Identifying and reporting text in a string

    Duplicate, sorry.
    Last edited by Jonmo1; 03-18-2013 at 01:38 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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