ExcelBanter - Cell Address in Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell Address in Formula (https://www.excelbanter.com/excel-discussion-misc-queries/161291-cell-address-formula.html)

Laury

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?

Gary''s Student

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?

Jim May

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?

All times are GMT +1. The time now is 12:57 PM.