Referencing to cells in a sorted list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference Formula Help 1
Fixed/Locked cell referencing 6
referencing cells in different workbooks 2
How do I make cell references return to normal? 4
Cell Referencing 1
How do I write a formula to obtain information from another spread 1
Values from referenced cells 6
Can a spreadsheet recognize the current directory it is in? 2

Back
Top