link cell in 1 wk-sht to another & keep it regardless of sorting

[papabear0207]

I am trying to link a cell ( an item price) in 1 worksheet to another
worksheet and have the correct price displayed regardless of any sorting of
data that I do. When I set up a link it works well except when I sort the
data in the worksheet 1 or 2

 

[Dave Peterson]

Instead of just pointing to the cell, maybe you could add a column of key values
to match up on.

Then you could use =vlookup() to return the price based on that match.


You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html