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:
Is giving the same result as:Please Login or Register to view this content.
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?Please Login or Register to view this content.
Can anyone explain what the non-array version with the Match(Index(),0,1,1) nesting means exactly?
Bookmarks