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?
Bookmarks