+ Reply to Thread
Results 1 to 2 of 2

Return any values from partial text in single reference column

  1. #1
    Registered User
    Join Date
    05-30-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Return any values from partial text in single reference column

    Hi all,

    I want to create a formula to return any values that match from a specific partial text. For example, in sheet 1 cell C1 contain specific make which TOYOTA. In column A there are list of all TOYOTA models such as TOYOTA CELICA, TOYOTA INNOVA, and so on. Then I want it
    to return any values from column A that contain text "TOYOTA" in return in column D ( D1 = TOYOTA ALTIS, D2 = TOYOTA CELICA ) Similar with this, then if I write "MAZDA" in cell E1, I want it to return value in column F ( F1= "MAZDA RX7").

    Make
    A
    TOYOTA ALTIS
    TOYOTA CELICA
    MAZDA RX7
    HONDA BRIO
    TOYOTA DYNO RINO

    C
    TOYOTA

    D
    return value for column A in row1
    return value for column A in row2
    return value for column A in row5



    I'm trying using =INDEX(A:A,MATCH("*"&$c$1&"*",A:A,0)+1). then drag down to see that "+1" could be automatically adjust to "+2". But it seem doesn't work.

    Thanks in advance for your support .
    Last edited by baba_jb; 05-30-2013 at 03:22 AM.

  2. #2
    Forum Contributor
    Join Date
    04-23-2013
    Location
    Abu Dhabi United Arab Emirates
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Return any values from partial text in single reference column

    Try this
    =index($a$1:$a$10,match("*"&$c1&"*",$a$1:$a$10,0),1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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