software

Hi,
eg. if c5=3
a[c5] should give me the contents of a3 like in any high level languageExcel does not treat a column as an array (table) so when C5=3, the formula
=A[C5] means nothing.
However, the formula =INDIRECT(quot;Aquot;amp;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

quot;sudhakarquot; gt; wrote in message
...
gt; Hi,
gt; eg. if c5=3
gt; a[c5] should give me the contents of a3 like in any high level
gt; language
gt;
Try something like this:

=INDIRECT(quot;Aquot;amp;C5)

Does that help?

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

XL2002, WinXP-Proquot;sudhakarquot; wrote:

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