Didnt quite know how to define what i wanted to ask in the title but ill
explain more clearly here....

I have used a function that will return a certain value in a cell, for
example it may return the value '5'. In this case, i then want the next cell
to return the value of cell A5. If the value is 4, i want it to retrun the
value of A4, if it is 3, return the value of A3, etc. Can anyone help me with
how to do this??