Think i know what you mean try using the formula 'INDIRECT'.
If you have a set of values in cells A1:A3 and using the value in cell A4 as the reference point and the result to output in cell A5
in A5 you would input =INDIRECT("A"&A4)
if A4 = 2 this would return the value inputted in cell A2.
Hope this makes sense, probably not but try experimenting with INDIRECT and using the help in excel, its a very useful formula for refenceing.