Cell Address in Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top