| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Address in Formula
Cell L5 has $C$16 as a value (it's the result of an =address formula).
I need to pull other data from that row. I tried, =OFFSET(L5,0,1) to pull the value on the same row but 1 column to the right, but I just get 0 as an answer. Is there something I have to do to make it recognize L5 as a cell address? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Address in Formula
=OFFSET(INDIRECT(L5),0,1)
-- Gary''s Student - gsnu200749 "Laury" wrote: Cell L5 has $C$16 as a value (it's the result of an =address formula). I need to pull other data from that row. I tried, =OFFSET(L5,0,1) to pull the value on the same row but 1 column to the right, but I just get 0 as an answer. Is there something I have to do to make it recognize L5 as a cell address? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Address in Formula
How 'bout:
=OFFSET(INDIRECT(L5),0,1) HTH Jim May "Laury" wrote: Cell L5 has $C$16 as a value (it's the result of an =address formula). I need to pull other data from that row. I tried, =OFFSET(L5,0,1) to pull the value on the same row but 1 column to the right, but I just get 0 as an answer. Is there something I have to do to make it recognize L5 as a cell address? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| store address in a cell and use it in formula | Excel Discussion (Misc queries) | |||
| Use Cell Address Lookup in formula | Excel Worksheet Functions | |||
| cell address from formula | Excel Discussion (Misc queries) | |||
| How do I use cell contents as an address in a formula | Excel Worksheet Functions | |||
| how do I write a formula: if (cell address) is less than X add Y | Excel Discussion (Misc queries) | |||
Linear Mode
