+ Reply to Thread
Results 1 to 4 of 4

Help with looking up Partial text multiple matches

  1. #1
    Registered User
    Join Date
    10-06-2011
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    34

    Help with looking up Partial text multiple matches

    please help.

    Example -- I have a sample in Sheet1 that is incomplete. I want to look in sheet2 column B and display the results of all partial match in column B, column C, Column D....... of sheet1

    i was able to get only one result when i used vlookup but do not know how to get the rest to display
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2212
    Posts
    37,018

    Re: Help with looking up Partial text multiple matches

    You could use this array formula:
    =IFERROR(INDEX(Sheet2!$B:$B,SMALL(IF(ISNUMBER(FIND(Sheet1!$A2,Sheet2!$A$2:$A$10)),ROW(Sheet2!$A$2:$A$10)),COLUMNS($B2:B2))),"")
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    10-06-2011
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    34

    Re: Help with looking up Partial text multiple matches

    Thanks Glenn!!! Worked perfectly

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2212
    Posts
    37,018

    Re: Help with looking up Partial text multiple matches

    You're welcome.

+ 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. Need excel formulas to return values for partial text matches
    By bp2010 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2016, 01:35 PM
  2. VLOOKUP Partial matches when searched text is longer than actual text
    By mockions in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-23-2015, 11:16 PM
  3. [SOLVED] Multiple partial matches
    By Grinfactor in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-28-2014, 01:15 PM
  4. [SOLVED] Finding partial text matches compared to a range
    By grifta67 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-17-2014, 04:38 PM
  5. [SOLVED] Count partial text matches in adjacent column
    By joshkvt in forum Excel General
    Replies: 6
    Last Post: 08-11-2014, 12:01 PM
  6. Formula that recoginizes partial text matches and concatenates them
    By Shadefalcon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-02-2014, 04:11 PM
  7. Replies: 2
    Last Post: 10-30-2007, 12:12 PM

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