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?