+ Reply to Thread
Results 1 to 5 of 5

Index, match, match Question!. Seems so simple but can't figure it out...

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    9

    Index, match, match Question!. Seems so simple but can't figure it out...

    So, my question is:
    Let’s say I type in “a”, I want it to match it to value in Row A whenever there is TEXT in a cell.

    So for example:
    - If I put in “c”, “2” should appear.
    - If I put in “g” or “h”, “5” should appear.

    Would I use Index, match, match in this case? If so, I’m very confused how to do it…


    I have attached an example.
    Attached Files Attached Files

  2. #2
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Index, match, match Question!. Seems so simple but can't figure it out...

    huikimhuikim,

    Attached is a modified version of your posted workbook.
    In column H are the letters
    In column I is the column header where that lettered row first has text

    Cell I2 and copied down uses this formula:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Index, match, match Question!. Seems so simple but can't figure it out...

    In other words, you want to return the column header that corresponds to the cell on a specific row that is not blank?

    Try this...

    A12 = some letter that is one of the row headers

    This array formula** entered in B12:

    =INDEX(B1:F1,MATCH(TRUE,INDEX(B2:F9,MATCH(A12,A2:A9,0),0)<>"",0))


    ** array formulas need to be entered using the key
    combination of CTRL,SHIFT,ENTER (not just ENTER).
    Hold down both the CTRL key and the SHIFT key
    then hit ENTER.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    05-29-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Index, match, match Question!. Seems so simple but can't figure it out...

    Holy crap, you guys are fast!!

    Thank you so much!!! It worked!

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Index, match, match Question!. Seems so simple but can't figure it out...

    You're welcome. We appreciate the feedback!

+ 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