IF, INDEX and MATCH

  • Thread starter Thread starter LJ
  • Start date Start date
L

LJ

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
 
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
 
Back
Top