Indexing / Cell Addressing

A

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")
 
Top