If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|