Your question isn't quite clear. I am assuming you have a cell reference
listed in a cell, and you want to offset from the cell reference?
i.e.: in cell B2 you have H3.
in that case, your formula would be:
=OFFSET(INDIRECT(B2),0,6)

If that isn't what you want, please provide a little more detail, current
data, current result data, expected result data.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Highlystrung" wrote:

I am using a formula =OFFSET(B2,0,6). The 6 refers to the 6th column to the
right but I want to use a reference to a cell range in there instead, in this
case H3. How can I do this?
--
thanks, Neil