| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pass Cell Address to OFFSET
Use INDIRECT.
Either wrap the CELL formula inside INDIRECT or put the CELL formula in another cell and use INDIRECT to reference that cell. -- Biff Microsoft Excel MVP "ExcelGuy555" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pass Cell Address to OFFSET
Excellent - Thanks much. I used this and it worked perfectly!
"T. Valko" wrote: Use INDIRECT. Either wrap the CELL formula inside INDIRECT or put the CELL formula in another cell and use INDIRECT to reference that cell. -- Biff Microsoft Excel MVP "ExcelGuy555" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pass Cell Address to OFFSET
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "ExcelGuy555" wrote in message ... Excellent - Thanks much. I used this and it worked perfectly! "T. Valko" wrote: Use INDIRECT. Either wrap the CELL formula inside INDIRECT or put the CELL formula in another cell and use INDIRECT to reference that cell. -- Biff Microsoft Excel MVP "ExcelGuy555" wrote in message ... 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. |
| Reply |
| 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 | |||
Hybrid Mode
