I would like to be able to use the information from a cell to determine which
cell is referenced to

It could be either a name or a number

On Wed, 21 Jun 2006 16:49:01 -0700, SCOTT
wrote:

I would like to be able to use the information from a cell to determine which
cell is referenced to

It could be either a name or a number

Perhaps the INDIRECT worksheet function is what you need?
--ron

I wasn't able to get that to work

What I would like to do is shown in the following example

if a cell reads 9 I would like to be able to use that cell to direct a
formula to that position

for example I want to go to J9

but if the cell reads 4 I want to go to J4

thanks allot

On Wed, 21 Jun 2006 19:46:02 -0700, SCOTT
wrote:

I wasn't able to get that to work

What I would like to do is shown in the following example

if a cell reads 9 I would like to be able to use that cell to direct a
formula to that position

for example I want to go to J9

but if the cell reads 4 I want to go to J4

thanks allot

If your "cell" is A1, then:

=INDEX(J:J,A1)

is one way of doing what you describe.


--ron

Say the cell that you use to enter the row number is A1.

Then, try this:

=INDIRECT("J"&A1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"SCOTT" wrote in message
...
I wasn't able to get that to work

What I would like to do is shown in the following example

if a cell reads 9 I would like to be able to use that cell to direct a
formula to that position

for example I want to go to J9

but if the cell reads 4 I want to go to J4

thanks allot

Hey Thanks heaps that was really helpful