Is this what you're looking for?

Type the row number to return into cell A2, and drag formula across columns:

=INDEX(Test!A:A,$A$2)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"dk" wrote in message
...
this is the hard way because we want row 35 we will have to retype all
fields
and change all to 35 is there anyway vlookup to refrence to a cell ex: a:25
instead of a value

"Ardus Petus" wrote:

In sheet <test1, cell A1 enter:
=test!A25

copy thru C1
B1 will hold =test!B25
C1 will hold =test!C25

HTH
--
AP

"dk" a écrit dans le message de news:
...
we like to get data from diffent sheet or work by putting in data cell
and
filling the rest of the columns automatically
ex; sheet 1 = test
sheet 2 = test1
sheet <test has in cell a:25 <35 : cell b:25 <50 cell c:25 <70
we will put in sheet <test1 cell a1- A link to sheet <test row <25
then
cell b1 will fill <50 cell c1 will fill <70
please explain we are new user