View Single Post
  #1   Report Post  
A_n_d_e_r_s
 
Posts: n/a
Default Indexing / Cell Addressing


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