formula to return value in a cell relative to another linked cell

The problem I am trying to solve is to have a cell return a cell value based on another linked cell. The cells I want to link are in separate tabs or could be another workbook.

For example if cell A5 in sheet2 is linked to A20 in sheet1...A5 has formula(=Sheet1!A20). I want the next cell B5 to look at A5 and return the value of cell Sheet1!D18.

So in essence I want the second cell to look at the first cell and return a value that is 3 columns over and 2 rows up.

Any help would be appreciated, thank you.

Is it always 3 over and 2 up? If it is, an offset argument might work, eg OFFSET(Sheet1!A20,3,-2). It's hard to give more help without an example worksheet to look at.

gak67 - Thank you for the response. Yes it will be a constant distance 3 over 2 up or similar from the value linked in the first cell but not from the first cell. Maybe you can answer this is there a way to collect the "sheet1!A20" from the first cell linked? I think offset will work if I can collect the reference from the first cell linked.

The FORMULATEXT function would do it, but you'd need to use some other functions with it to get just the part you need, and you'd need to use it within an INDRECT function.

FORMULATEXT doesn't work in 2007. Looks like a new function for 2013? I have figured out a work around but If I can get this work it will be better. Thanks again for the help. Offset is very useful. I can see other uses for it. Just not complete for this case...yet anyway.