I apologize in advance if there is an obvious solution to this that I am
missing:

I want to use a formula that will refer to a certain cell that varies from
sheet to sheet depending on the value of another cell.

I want the cell to refer to cell N"x"
N= the column in which to find the value
"x"= is a number contained in cell T2
On one sheet, T2 is "6" and then on the next it is "34"
If T2 is 6, I would like the cell to reference the data in column N row 6.
If T2 is 34, I would like the cell to reference the data in column N row 34.

The value of T2 changes on every sheet and I would like to avoid having to
retype formulas everytime T2 changes.

I hope this is slightly clearer than mud :-)

Thanks JD

Try using the Indirect function

=Indirect("N"&T2)

"JD01904" wrote in message
...
I apologize in advance if there is an obvious solution to this that I am
missing:

I want to use a formula that will refer to a certain cell that varies from
sheet to sheet depending on the value of another cell.

I want the cell to refer to cell N"x"
N= the column in which to find the value
"x"= is a number contained in cell T2
On one sheet, T2 is "6" and then on the next it is "34"
If T2 is 6, I would like the cell to reference the data in column N row 6.
If T2 is 34, I would like the cell to reference the data in column N row
34.

The value of T2 changes on every sheet and I would like to avoid having to
retype formulas everytime T2 changes.

I hope this is slightly clearer than mud :-)

Thanks JD

BEAUTIFUL! Thanks Barb. Knew it had to be something simple :-)

"Barb Reinhardt" wrote:

Try using the Indirect function

=Indirect("N"&T2)

"JD01904" wrote in message
...
I apologize in advance if there is an obvious solution to this that I am
missing:

I want to use a formula that will refer to a certain cell that varies from
sheet to sheet depending on the value of another cell.

I want the cell to refer to cell N"x"
N= the column in which to find the value
"x"= is a number contained in cell T2
On one sheet, T2 is "6" and then on the next it is "34"
If T2 is 6, I would like the cell to reference the data in column N row 6.
If T2 is 34, I would like the cell to reference the data in column N row
34.

The value of T2 changes on every sheet and I would like to avoid having to
retype formulas everytime T2 changes.

I hope this is slightly clearer than mud :-)

Thanks JD