Results 1 to 5 of 5

Nested Match(index()) vs. Match() array formula.

Threaded View

  1. #1
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Unhappy Nested Match(index()) vs. Match() array formula.

    Hello,

    I'm trying to get over my hatred of array formulas, so I've been looking through the forums for awesome array-formula examples...

    This one has me stumped and I was hoping to get some help....on my "lowestPrice" sheet I have an array and non-array solution in columns D and F respectively.

    Basically, I'm trying to figure out why the array formula:
    {=INDEX($H$3:$H$11,MATCH(1,(A3=$I$3:$I$11)*(E3=$J$3:$J$11),0),0)}
    Is giving the same result as:
    =INDEX($H$3:$H$11,MATCH(1,INDEX(($I$3:$I$11=A3)*($J$3:$J$11=E3),0,1,1),0),1)
    The array version makes sense to me....but the non-array version seems dimensionally incorrect or somethings...how is match bringing back the row with a static "0,1,1" for the index....does this mean that INDEX is bringing back the 0th row - 1st column value of an array?

    Can anyone explain what the non-array version with the Match(Index(),0,1,1) nesting means exactly?
    Attached Files Attached Files
    Last edited by GeneralDisarray; 10-14-2011 at 07:58 AM.
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

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