=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?