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