Excel relative reference lost after sorting

O

Olivier B

Hello,

I have a sheet like this :
Column A Column B
2 =A2 (so it displays value 1)
1

I sort by column A. I expect to see :

Column A Column B
1
2 =A1 (so it still displays value 1)

Or I have :
Column A Column B
1
2 =A3 (so it still displays no value )

How is it possible and how can I have the sort I expect : the line with
value in column A is 2 still refers to the line with value in the column A is
1.

Thanks,

Olivier
 
F

Frank Kabel

Hi
this is not possible. A cell reference always refer to the cell and not to
the content of this cell. If you have a unique iD for each row you may use
VLOOKUP
 
Top