sorry about that a1 to a100 would not do well.

"JohnR" wrote:

This helped a great deal and it worked just fine with only one change, I had
to change the $A$100 to $J$100 in order to include the entire table.

"bj" wrote:

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.