Indexing / Cell Addressing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find and replace \n wildcards like word 4
Sum across multiple worksheets 4
Multiple options- answer in single cel 2
copy and paste the cell with formula ="1" 3
mr t.valko ..help 8
IF(ISNA.. or ISERROR? question.. 3
Sumproduct where cell values are the same in a sorted column 1
Problem using ADDRESS() in SUMPRODUCT() 2

Back
Top