Prev: How do I stop text from disappearing when I wrap text in Excel?
Next: formula for displaying only the last entry of a group of cells
From: LJ on 22 Mar 2010 09:06
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
From: Bernard Liengme on 22 Mar 2010 09:25
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" <ljasonmiller(a)gmail.com> wrote in message
news:fc1df96a-dbff-4075-897e-c5a70a87f7fc(a)t20g2000yqe.googlegroups.com...
> 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

 | 
Pages: 1
Prev: How do I stop text from disappearing when I wrap text in Excel?
Next: formula for displaying only the last entry of a group of cells