Results 1 to 3 of 3

Want to extract partial matches from a list and add to existing list of retreived matches

Threaded View

  1. #1
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Want to extract partial matches from a list and add to existing list of retreived matches

    Have an array formula which works fine in creating a list of matches from a table.

    I'd like to include "partial" matches as well. Spreadhseet attached.

    Want to include; in the results section beginning in cell B10, the "ww", and "bb" in the list because in the source data table, they also contain the value of "12".

    I've tried adding "*"& etc to the A10 lookup value but it seems to hose the formula and it returns nothing.

    TIA for any ideas.

    Pete

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Looking to extract multiple matches from a list
    By Castorr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-15-2019, 12:03 PM
  2. [SOLVED] Formula to Extract a List of Matches
    By peterschein in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 03-27-2019, 01:06 PM
  3. Replies: 2
    Last Post: 03-01-2019, 02:00 PM
  4. Vlookup - create new list from existing list based on partial match
    By unknown_brother in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-15-2018, 02:31 AM
  5. Replies: 9
    Last Post: 12-09-2016, 10:43 AM
  6. [SOLVED] Summing the matches of one column only if its corresponding description matches a list
    By bishop-jese-erl in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-19-2015, 04:26 PM
  7. extract email address from the cell if it matches one from the list
    By mumsys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2014, 10:34 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