Formula to return value of cell relative to another cell in separate worksheet

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

Thank you for such a quick response. I think that will work. I need to copy and paste the new formula into many cells, which will make your first step difficult but not impossible. I did not set up my spreadsheet properly to begin with. For now I'm going to try to use INDEX..MATCH get what I need. If that doesn't work, I will use your approach. Thank you again so much. Jake