The way I do this type of operation is to insert a new column A fill the
column with a numbber sequence;
make your equation be =vlookup(reference number,SHEET1!$A$1:$A$100,2,false)
Where the reference number is the number in colimn A next to the cell you
want the value for

When you sort sheet 1 make sure bbothe columns are sorted.

"JohnR" wrote:



"bj" wrote:

Could you give an example of what you want it to do and what it is doing. If
the cell reference were A3 it should still be A3 after the sort of sheet 1,
do you want it to follow the sort?

"JohnR" wrote:

When using "=(SHEET1!cell_reference)" in sheet2, if I sort sheet1, sheet2
does not have the correct data.
bj, Yes , I would like it to follow the sort.