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??

You use the IDIRECT function. Say the cell containing the value is D1, then
where you want to show the value of the related cell in col A, enter the
following formula:
=INDIRECT("A"&D1) With sy a 5 in D1, you will get the value of A5.

"Frazer" wrote:

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??

if you dont have too many values
if(A1=5,a5,if(a1=4,a4,if(a1=3,a3,"")))
--
paul

remove nospam for email addy!



"Frazer" wrote:

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??