Indexing based on the cell address in a cell

[jmark]

Hi -
I'm new here but have been using the forum for my Excel and VBA questions for years. I've always been able to find the answer to my questions without posting in the past, but not able with this one.

Is it possible to use the Index or Offset functions to "offset" from the cell reference in a cell? This is confusing so I hope this helps

Cell B4 contains =Data!c9

I want to use the "Data!c9" as a reference to offset to other data in the columns that follow.

Is this possible? How is it done. At this point, not using VBA for this.

Thanks in advance -

jmark

 

[Takae]

Like this?

=OFFSET(INDIRECT(B4),1,1)