IF, INDEX and MATCH
 

I was using the formula below to match 2 indicators listed within an
array. I have another 2 indicators that I CANNOT add to the array.
They lie in cells AA2 and AB2. How can I modify the formula below to
Index all 4 indicators.

=INDEX($A$1:$E$42, MATCH(Y2,$A$1:$A$42,0),MATCH(Z2,$A$1:$E$1,0))

Thanks for the help in advance.

LJ

IF, INDEX and MATCH
 

An array is by definition two-dimensional so it is hard to see how you could
point to a cell in the array using an index with more than two entries.
Could you give some simple examples?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"LJ" wrote in message
...
I was using the formula below to match 2 indicators listed within an
array. I have another 2 indicators that I CANNOT add to the array.
They lie in cells AA2 and AB2. How can I modify the formula below to
Index all 4 indicators.

=INDEX($A$1:$E$42, MATCH(Y2,$A$1:$A$42,0),MATCH(Z2,$A$1:$E$1,0))

Thanks for the help in advance.

LJ