How to feed the contents of a cell as row index?
 

Hi,
eg. if c5=3
a[c5] should give me the contents of a3 like in any high level language

How to feed the contents of a cell as row index?
 

Excel does not treat a column as an array (table) so when C5=3, the formula
=A[C5] means nothing.
However, the formula =INDIRECT("A"&C5) will be equivalent to =A3 when C5 has
value 3
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"sudhakar" wrote in message
...
Hi,
eg. if c5=3
a[c5] should give me the contents of a3 like in any high level
language

How to feed the contents of a cell as row index?
 

Try something like this:

=INDIRECT("A"&C5)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"sudhakar" wrote:

Hi,
eg. if c5=3
a[c5] should give me the contents of a3 like in any high level language