Referencing to cells in a sorted list

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?

AFAIK, Excel can't do that.

HTH
--
AP

"tbobster" <tbobster@discussions.microsoft.com> a écrit dans le message de
news: 7B2DCDFD-A1B6-452C-B34B-67302D442EDC@microsoft.com...
>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?
>

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

"Ardus Petus" wrote:

> AFAIK, Excel can't do that.
>
> HTH
> --
> AP
>
> "tbobster" <tbobster@discussions.microsoft.com> a écrit dans le message de
> news: 7B2DCDFD-A1B6-452C-B34B-67302D442EDC@microsoft.com...
> >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?
> >
>
>
>