Referencing to cells in a sorted list

[tbobster]

I have a list in a spreadsheet. In another part of the spreadsheet, I am
referring to cells in the list. When I sort the list, the cells referenced
have different data in them. Is there a way to reference the list so that
cells referring to the fields in the list follow the specific item to which
they are referring?

Is this clear?

 

[Ardus Petus]

AFAIK, Excel can't do that.

HTH

 

[Ronco]

Maybe the =VLOOKUP function referencing your original list would do what you
need.