View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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