When you drag down the formula, the addresses will update automatically

--
AP

"dk" a écrit dans le message de news:
...
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