Results 1 to 8 of 8

Find word within text that matches range and Vlookup the result

Threaded View

  1. #1
    Registered User
    Join Date
    08-26-2014
    Location
    Prague
    MS-Off Ver
    2016
    Posts
    8

    Find word within text that matches range and Vlookup the result

    Hi,

    I need to perform a search within text to find out what word is included (from a list of words within range) and then vlookup/offset this result.

    For example: I need to find text within column "B" that matches any row from column "E" and write corresponding class from column "F".
    Specifically, it finds word salmon in B3 that matches a result from range in column "E" then it matches Salmon with Fish and shows it as a result - I need to know what word or row it matches so I can vlookup or offset this to get Fish from column "F".

    Example.JPG

    I am able to say whether any word from column "E" is present but I can't say what word it is :/

    Thank a lot for your ideas.

    Lukas
    Last edited by snakeCZ; 11-18-2015 at 08:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find word(s) within text string that matches a list of keywords - NOT case sensitive
    By gbm222 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2013, 02:15 AM
  2. Formula to Find If Text In a Cell Matches Another Range of Cells
    By purplesamcat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2013, 07:45 PM
  3. [SOLVED] find word(s) within text string that matches a list of keywords
    By ecc34_11 in forum Excel General
    Replies: 10
    Last Post: 07-11-2012, 06:04 AM
  4. [SOLVED] find first word within text string that matches from a list of keywords
    By exclusivebiz in forum Excel General
    Replies: 5
    Last Post: 04-13-2012, 03:29 PM
  5. Replies: 6
    Last Post: 04-06-2012, 04:18 PM
  6. [SOLVED] Find text in a string that matches value(s) in a range
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-15-2006, 02:35 PM
  7. [SOLVED] Find the POSITION IN A RANGE of text in a string that matches value(s) in a range
    By Cornell1992 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2006, 03:25 PM

Tags for this Thread

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