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