| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing to cells in a sorted list
AFAIK, Excel can't do that.
HTH -- AP "tbobster" a écrit dans le message de news: ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing to cells in a sorted list
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" a écrit dans le message de news: ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a drop-down list to change other cells in Excel? | Excel Worksheet Functions | |||
| Auto Fill Cells, When Choosing From Drop-Down List... | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Need sorted validation list | Excel Worksheet Functions | |||
| Data Validation List Option Affecting Other Cells? | Excel Worksheet Functions | |||
Linear Mode
