G Guest Mar 9, 2006 #1 Hi, eg. if c5=3 a[c5] should give me the contents of a3 like in any high level language
B Bernard Liengme Mar 9, 2006 #2 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
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
G Guest Mar 9, 2006 #3 Try something like this: =INDIRECT("A"&C5) Does that help? *********** Regards, Ron XL2002, WinXP-Pro
Try something like this: =INDIRECT("A"&C5) Does that help? *********** Regards, Ron XL2002, WinXP-Pro
