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

S

sudhakar

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

Bernard Liengme

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
 
R

Ron Coderre

Try something like this:

=INDIRECT("A"&C5)

Does that help?

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

XL2002, WinXP-Pro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
change cell color depending on two cell values 1
Save result of IF function 6
Insert Index into a Table 1
Show cell contents depending on other cells information 7
Fill Series in Filtered Rows 2
pasting content copied from nonadajacent cells 1
Excel formula to list out the info according to criterion 3

Top