Hi I dont know if this is possible, but hope it is.

Suppose i have the following table, i want the value in D10, to go the steps back in column C that the value in B2 states.
In the shown case, the value is 4, so D10 goes 4 steps back in C, and gets the value 5. If i change the value in B2 to lets say 3, D10 would automatically give the value 6 instead, as this is 3 steps back in column c.

Hope it makes sense

Screen Shot 2015-12-10 at 16.34.39.png