IF, INDEX and MATCH

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top