Cell Address in Formula

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

finding the cell adjacent to the max value in a row with formula 4
Formula help 6
spot the mistake in formula 3
Very Slow Calculating 4
Multiple Conditions in a Formula 2
Excel VBA 1
Help !!! 2
Conditional Format based on forumula result 5

Top