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

1. ## 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: ``Please Login or Register  to view this content.``
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?

Can anyone explain what the non-array version with the Match(Index(),0,1,1) nesting means exactly?  Register To Reply

2. ## Re: Nested Match(index()) vs. Match() array formula.  Register To Reply

3. ## Re: Nested Match(index()) vs. Match() array formula.

was hoping you were on...as you were the one that posted that soln' to begin with thank you. will definitely read through it...  Register To Reply

4. ## Re: Nested Match(index()) vs. Match() array formula.

So by replacing

(A3=\$I\$3:\$I\$11)*(E3=\$J\$3:\$J\$11)

with

INDEX((A3=\$I\$3:\$I\$11)*(E3=\$J\$3:\$J\$11),0)

you don't need to confirm with CSE as the INDEX with the 0 row, coerces the return of an array of values. In this case 1's and 0's since you are multiplying two conditional arrays together. Then the 1 is matched against the first 1 in the INDEX resultant array to return corresponding position.

Use the Evaluate formula tool in Formulas tab to see the steps.  Register To Reply

5. ## Re: Nested Match(index()) vs. Match() array formula.

yep, i got the 'vector' of ones and zeros part, where: true*false or false*true or false*false = 0 and true*true=1

thank you again for the link, the 0 in the "rows" place signals to return an entire array of values...never would have just figured that out on my own   Register To Reply