+ Reply to Thread
Results 1 to 3 of 3

finding partial text ,In the case of more than one match

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2007
    Posts
    2

    finding partial text ,In the case of more than one match

    \1

    I'm looking to use Excel to finding partial text In the case of more than one match

    I used the following formula in cell C12:
    =IFERROR(INDEX($C$2:$C$8, SMALL(IF($B12=$B$2:$B$8, ROW($B$2:$B$8)-MIN(ROW($B$2:$B$8))+1, ""),COLUMNS($B12:B12))),"")

    But it's work only 100% match word not by partial text.
    (In the image , That's I expect to do.)

    Best Regards.
    Attached Files Attached Files
    Last edited by fartdog01; 02-20-2014 at 09:21 AM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: finding partial text ,In the case of more than one match

    Try this version

    =IFERROR(INDEX($C$2:$C$8, SMALL(IF(ISNUMBER(SEARCH($B12,$B$2:$B$8)), ROW($B$2:$B$8)-MIN(ROW($B$2:$B$8))+1, ""),COLUMNS($B12:B12))),"")
    Audere est facere

  3. #3
    Registered User
    Join Date
    02-20-2014
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: finding partial text ,In the case of more than one match

    Many Thanks! daddylonglegs
    It's worked.

    thanks for you help!

+ 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. finding partial text in an index match formula
    By garyaw in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-30-2015, 04:27 PM
  2. vloopup with partial text match
    By piedimonster in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2013, 02:02 PM
  3. [SOLVED] Finding a partial match within a column
    By kestefon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2013, 02:14 PM
  4. [SOLVED] Finding a partial match within a list on another tab
    By IN_FOR_SIN in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2013, 10:33 AM
  5. [SOLVED] partial/absolute text match
    By george in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2006, 01:20 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