| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Passing Cell Address to Offset
The following function returns the cell address I want to use in an offset
function: =ADDRESS(MATCH(C$8,C$10:C$28,0)+8,D$1,4) however, if I imbed this function in the first argument of the offset function i.e. OFFSET(ADDRESS(MATCH(C$8,C$10:C$28,0)+8,D$1,4),-9,0,1,1) I get "The formula you typed contains an error." Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| look up a value that results in a cell address | New Users to Excel | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
| How do I dynamically retrieve the cell address of the last cell t. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| How do I link an identical cell address across multiple worksheet. | Excel Worksheet Functions | |||
Threaded Mode
