+ Reply to Thread
Results 1 to 3 of 3

Find specific text in cell that matches range, then display specific text

  1. #1
    Registered User
    Join Date
    05-28-2009
    Location
    Oxford
    MS-Off Ver
    Excel 2007
    Posts
    86

    Find specific text in cell that matches range, then display specific text

    I'm trying to find vehicle make and model in a cell containing a lot of text and then display that in the formula cell. For example if A1 is a paragraph that contains somewhere within it "Ford" & "Ranger". I want B1 to display "Ford" and C1 to display "Ranger". I have a list of vehicles makes (column A) and models (column B) on a seperate sheet.

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Find specific text in cell that matches range, then display specific text

    This should get you started:
    Attached Files Attached Files
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Find specific text in cell that matches range, then display specific text

    Watch out for 'normal' words that are also vehicle names but are not meant as such...

    "My seat in the plane to Ibiza was more comfortable than that in my Ford Ranger."
    You do want to find Ford Ranger, but you do not want to find Seat Ibiza
    When I say semicolon, u say comma!

+ 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. If cell X matches a value in a cell range, return "specific text" - HELP :(
    By paulandrewlee in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-02-2013, 07:06 PM
  2. Display msgbox when specific text entered in specific range
    By Ali_Riza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2012, 08:05 AM
  3. Replies: 1
    Last Post: 06-22-2012, 02:18 PM
  4. 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
  5. Extract specific text in Cell A1 and display in A2
    By Dave32 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-22-2008, 08:27 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