Hello,

I have what seems should be a straightforward need, but I've tried various forms of OFFSET, ADDRESS, etc. and can't seem to find a solution.

In one worksheet ("Current") I have cells returning the value of cells in another worksheet ("Another"). So, for example, in "Current" cell A1 I have "='Another'!B2". Easy so far.

Now, beneath 'Current'A1, I need a formula which will return the value, say, five columns to the right of the 'Another' cell referred to in A1, or in the example, 'Another'!G2. In a different cell I might want 'Another'!I2, or the value seven columns to the right.

I need these cells to return the value in "Another" by referring to the cell in the "Current" worksheet. So in some way the formula needs to have 'Current'!A1 somewhere in it that will give me the value I want in the "Another" worksheet.

I very much appreciate any help. Jake