how do I refer to a cell using information from other cells

S

SCOTT

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
 
R

Ron Rosenfeld

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
Click to expand...

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

SCOTT

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
 
R

Ron Rosenfeld

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
Click to expand...

If your "cell" is A1, then:

=INDEX(J:J,A1)

is one way of doing what you describe.


--ron
 
R

Ragdyer

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

Then, try this:

=INDIRECT("J"&A1)
 
Top