+ Reply to Thread
Results 1 to 7 of 7

function INDEX MATCH MATCH doesn´t work

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    São Paulo
    MS-Off Ver
    Excel 2010
    Posts
    17

    function INDEX MATCH MATCH doesn´t work

    Hi Folks!,

    I'm trying to use the INDEX function combined with MATCH to lines and MATCH to columns. However, for some unknown reason, is not working. The follow link shows the details more accurately.

    https://www.sendspace.com/file/2o9azy

    I thank the help and attention of those who can contribute.

    Thank U!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,311

    Re: function INDEX MATCH MATCH doesn´t work

    Please upload your workbook to the forum, not all members are able - or willing - to access file-hosting sites
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: function INDEX MATCH MATCH doesn´t work

    Please attach the file in this website itself

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,701

    Re: function INDEX MATCH MATCH doesn´t work

    Change
    =INDEX('SharePrice EUA_YyyyMmDd'!A1:CJ3132,MATCH(GO_EUA_1!B2,'SharePrice EUA_YyyyMmDd'!A1:CJ3132,0),MATCH(GO_EUA_1!A2,'SharePrice EUA_YyyyMmDd'!A1:CJ1,0))
    As
    =INDEX('SharePrice EUA_YyyyMmDd'!$A$1:$CJ$3132,MATCH(GO_EUA_1!B2,'SharePrice EUA_YyyyMmDd'!$A$1:$A$3132,0),MATCH(GO_EUA_1!A2,'SharePrice EUA_YyyyMmDd'!$A$1:$CJ$1,0))
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,311

    Re: function INDEX MATCH MATCH doesn´t work

    Based on the formula that nflsales posted, I would point out that the range used in MATCH must be a single column or row, not an array (multiple rows/column)...it appears that you have an array for the 1st match...A1:CJ3132

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

    Re: function INDEX MATCH MATCH doesn´t work

    If this was my file the first thing I would do is change those really long and hard to read sheet names!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,311

    Re: function INDEX MATCH MATCH doesn´t work

    Good point, Tony, but I guess if you know what they represent, it wouldnt be so hard to read lol

+ 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. Index + Match doesn't work with text
    By blueturnaround in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-19-2014, 01:18 PM
  2. Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??
    By Underling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 09:01 PM
  3. [SOLVED] Index, Match & And function doesn't seem to be working when there is duplicate data
    By penexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-26-2013, 07:08 PM
  4. Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  5. Replies: 5
    Last Post: 01-06-2012, 08:00 PM

Tags for this Thread

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