Results 1 to 4 of 4

Thread: Index not returning array

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Index not returning array

    I am trying to use an index function to return an array for this function:

    =(INDEX(C5:F8,MATCH(H5,B5:B8,0),0))

    For context, C5:F8 is a set of values for the B5:B8 set of dates. I'm trying to return a row array of elements indexed off the date.

    There is no problem with my match function. I don't have a problem with the index function when I have a value for the column number.

    My question is, I thought excel was supposed to return an array when the column number is 0? The excel I am working on is 2010, could this be the problem?

    Thank you.

  2. #2
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,659
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Index not returning array

    It does return an array. What are you trying to do with it? If you're using that as part of a larger formula, make sure that it's an array formula (either with Control+Shift+Enter, or in an array-enabled function such as SUMPRODUCT). If you just want to return the values to the sheet, select a 1-row by 4-column range, enter the formula in the formula bar, then confirm with Control+Shift+Enter, and you should see all 4 matching values in the 4 selected cells.

    If you want to do something else with the array, let us know.
    Last edited by Eric W; Aug 29th, 2019 at 12:33 PM.
    Cheers,
    Eric

    When you eliminate the impossible, whatever remains, however improbable, must be the truth.

    -Posting guidelines, forum rules, terms of use, FAQs, BB codes, See how to search the forum
    -Post a screen shot with the HTML Maker

  3. #3
    New Member
    Join Date
    Aug 2019
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Index not returning array

    Quote Originally Posted by Eric W View Post
    It does return an array. What are you trying to do with it? If you're using that as part of a larger formula, make sure that it's an array formula (either with Control+Shift+Enter, or in an array-enabled function such as SUMPRODUCT). If you just want to return the values to the sheet, select a 1-row by 4-column range, enter the formula in the formula bar, then confirm with Control+Shift+Enter, and you should see all 4 matching values in the 4 selected cells.

    If you want to do something else with the array, let us know.
    I see, I was not doing anything with it once i created it! Duh.

    Thank you.

  4. #4
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,659
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Index not returning array

    You're welcome.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •