index

[Stan Altshuller]

Hi All!

I need to specify an indx value but need the index names to reflect the
values in a row going across.
i.e.
=INDEX(C1,MATCH(A6,ticker1,0))

the cell C1 has the name of an array, C2 has teh name of the next array etc.
I get the #REF error, but if I write in the actual index nmae, the value is
correct.
Please help!!!

Thanks!
Stan

 

[RagDyer]

Try this:

=INDEX(INDIRECT(C1),MATCH(A6,ticker1,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi All!

I need to specify an indx value but need the index names to reflect the
values in a row going across.
i.e.
=INDEX(C1,MATCH(A6,ticker1,0))

the cell C1 has the name of an array, C2 has teh name of the next array etc.
I get the #REF error, but if I write in the actual index nmae, the value is
correct.
Please help!!!

Thanks!
Stan