Hi John,

Use the INDIRECT() function. Look in HELP for details. Post again in this
thread if you have problems.

--
Kind regards,

Niek Otten

"John ferguson" <John wrote in message
...
I have 4 columns of data, X co-ordinates, y co-ordinates, frame number, and
track number. The number of co-ordinates varies per track. I want to take
the
first set of coordinates off the rest of the co-ordinates but as the
number
varies I can't set a block of formulas where you take coordinate set 1 of
the
first 30 values and set 31 of the next 30 values and so on. I think I need
to
use the frame number to set which cell i use as the zero value. To do this
i
would need to make a formula that uses a number in a cell (in my case
frame
number) to alter a cell reference. Ie =A40-20 (Value in refernce cell)
which
should give a new cell reference of a20 and not the value in a40 - 20. I
hope
this makes sense.

John