+ Reply to Thread
Results 1 to 2 of 2

Return values from string that match defined range within a single cell

  1. #1
    Forum Contributor
    Join Date
    03-26-2014
    Location
    Kentucky
    MS-Off Ver
    Excel 2013
    Posts
    128

    Return values from string that match defined range within a single cell

    How can I search through a string and return only the values that are in a defined named range within a singe cell? Ex: assume cell A1 contains the string "blue_yellow_red_orange". However, I want cell B2 to return only those substrings that are present in my named range "Colors", which contains yellow, orange, and purple. Therefore, the output for B2 should be "yellow, orange".

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Return values from string that match defined range within a single cell

    I;m thinking VBA though I don'y have a solution.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. [SOLVED] return FROM TO values from custom defined range , and return all possible combination
    By raj soni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2016, 01:38 PM
  2. Return Reference of single column from defined range in VBA
    By DH123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2015, 04:18 AM
  3. [SOLVED] Search for String in Range, If Match, Return Matching Cell Value
    By ryanb909 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-21-2013, 02:27 AM
  4. Replies: 5
    Last Post: 07-07-2013, 03:39 PM
  5. Replies: 17
    Last Post: 12-05-2012, 09:01 PM
  6. Replies: 3
    Last Post: 10-03-2012, 03:09 AM
  7. Search text string for range of text values - return match
    By crugg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2010, 09:55 AM

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