Indexing / Cell Addressing

[A_n_d_e_r_s]

Is there a way of indirect cell addressing in excel ?

e.g.

direct cell addressing value = A10 or $A$10

indirect cell addressing value = A(B1) for row indirect address
(where content of B1 = 10)
value = ((C2)(B1))

(where content of B1 = 10)
(where content of C2 = "A")

[Jason Morin]

=INDIRECT(C2&B10)

HTH
Jason
Atlanta, GA

>-----Original Message-----
>
>Is there a way of indirect cell addressing in excel ?
>
>e.g.
>
>direct cell addressing value = A10 or $A$10
>
>indirect cell addressing value = A(B1) for row
indirect address
>(where content of B1 = 10)
> value = ((C2)
(B1))
>
>(where content of B1 = 10)
>(where content of C2 = "A")
>.
>