Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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") |
#2
|
|||
|
|||
=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") . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |