| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pass Cell Address to OFFSET
Hello. I have calculated a cell address of say $A$1 using the CELL function.
I would now like to use the OFFSET function to get the value of what's in say cell B1. How do I pass this text cell address to a usable input into the OFFSET function. Thank you very much for your input. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1) | Excel Worksheet Functions | |||
| =OFFSET(cell("address"),-1,0) | Excel Worksheet Functions | |||
| SUM, OFFSET and CELL("address") | Excel Worksheet Functions | |||
| Offset with Cell("address") | Excel Worksheet Functions | |||
| Passing Cell Address to Offset | Excel Worksheet Functions | |||
Threaded Mode
