+ Reply to Thread
Results 1 to 3 of 3

Match Issue - Consolidate Columns of Data With Match/Index/etc?

  1. #1
    Registered User
    Join Date
    12-20-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2010
    Posts
    12

    Match Issue - Consolidate Columns of Data With Match/Index/etc?

    Hi,

    So this is a bit tricky to explain but I've attached a sample spreadsheet with data, the errant result I'm getting, the desired result, and then additional calculations I plan to do on the data once I get the desired result.

    Effectively, the Match function I'm using appears to search right to left as opposed to left to right, so it returns bad data. I've tried hlookups, indexes, offsets, etc, and racked my brain to find other solutions but I can't seem to get there.

    If anyone can resolve the match issue or figure out another way to get to my desired result, I will be thoroughly impressed, forever in your debt, and I will sing your praises through all the land.

    Thanks,
    Kevin
    Attached Files Attached Files

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: Match Issue - Consolidate Columns of Data With Match/Index/etc?

    Try this..

    In G5
    =INDEX(B$4:E$4,MATCH(TRUE,INDEX(B5:E5<>"",0),0))
    Copy down

    In I5
    =INDEX(B5:E5,MATCH(G10,B$4:E$4,0))
    Copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    12-20-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Match Issue - Consolidate Columns of Data With Match/Index/etc?

    You just blew my mind. Just curious, can you explain how that works? When you break the Index and Match functions out into separate cells, it doesn't work because the embedded Index argument returns False for records 2 and 4 so the Match function can't resolve it.

+ 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. Issue using Index/Match to pull multiple occurrences of "Match" criteria
    By aridfriedman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2014, 11:38 AM
  2. [SOLVED] Index Match table using two columns of data
    By purdue7997 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2013, 08:25 AM
  3. Replies: 3
    Last Post: 05-08-2013, 02:10 PM
  4. [SOLVED] index match match - issue
    By jw01 in forum Excel General
    Replies: 2
    Last Post: 11-27-2012, 03:53 PM
  5. Consolidate Index/Match formula into variable range
    By jeffreybrown in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-10-2012, 11:16 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