+ Reply to Thread
Results 1 to 3 of 3

Help me analyze this INDEX/MATCH function

  1. #1
    Forum Contributor
    Join Date
    04-14-2008
    Location
    Fort Collins, Co
    MS-Off Ver
    2016
    Posts
    107

    Help me analyze this INDEX/MATCH function

    I am trying to figure out the spreadsheet of a coworker who has retired, but left no training or documentation behind.
    This is one part of a larger formula, and it's giving me so much trouble!

    Let's say this formula is in Sheet1. I've simplified the references to make it easier to read.
    =(INDEX(Sheet2!A:AP,MATCH(C1,Sheet2!A:A,0)))

    As I understand it, since the range for INDEX is more than one column, the creator of the formula should have used a column reference as a 3rd argument, but there isn't one.
    I am getting all zeros back from this formula, no matter what row it's looking at. I think there is an error here.

    What column data will this return by default since the creator did not specify a column for the INDEX?

    Any help is appreciated. I"m pulling my hair out with this one.
    Last edited by 4am; 03-29-2018 at 05:14 PM.
    Is That Your Spreadsheet Or Did Your Database Just Throw Up?


  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,292

    Re: Help me analyze this INDEX/MATCH function

    I cannot replicate your observation. When I do something similar (multi column reference) and only give it one coordinate, Excel gives me a #REF error.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    04-14-2008
    Location
    Fort Collins, Co
    MS-Off Ver
    2016
    Posts
    107

    Re: Help me analyze this INDEX/MATCH function

    Thank you Mr. Shorty. Because of your observation, I realized I messed up. The first arguemnt of the INDEX function (which has been simplified for the purposes of this question) was a named range that was named VERY similarly (1 letter difference! ) to another range. The range in question is indeed a single column range. So I have solved my problem. Can't believe how long I spent on this! Sometimes you just need other eyes on something. Appreciated.

+ 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. [SOLVED] Large Data - Index Match Match with another function?
    By d7882 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-12-2017, 03:51 PM
  2. Need help in Index, Match usage to match multiple criteria in sum function
    By Summer0830 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2017, 02:47 AM
  3. Problems applying INDEX-MATCH-MATCH function on other data
    By LennartB in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2015, 05:33 AM
  4. function INDEX MATCH MATCH doesn´t work
    By leonelcd in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2015, 11:36 AM
  5. [SOLVED] Stuck on Match function with #N/A; attempting to reverse Index/Match
    By Cappytano in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-10-2014, 06:39 PM
  6. Replies: 6
    Last Post: 03-17-2014, 08:10 PM
  7. Replies: 3
    Last Post: 06-17-2013, 12:37 PM

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