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

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