| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables and VLOOKUP
I have set up a pivot table to sort similar items of a sheet that constantly
grows and then I enter information next to the pivot table and that information if returned to sheet 1 using VLOOKUP. My problem is if I change something after I've already entered the data next to the pivot table, the sort it had previously changed and the data next to the pivot table is not correct. I use office 2003. Is there a better way at doing this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Tables and VLOOKUP
Where is the source data for the pivot table?
Maybe you could enter the information in a column there, and use Vlookup on that table. Confused5627 wrote: I have set up a pivot table to sort similar items of a sheet that constantly grows and then I enter information next to the pivot table and that information if returned to sheet 1 using VLOOKUP. My problem is if I change something after I've already entered the data next to the pivot table, the sort it had previously changed and the data next to the pivot table is not correct. I use office 2003. Is there a better way at doing this? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
| Vlookup in pivot tables | Excel Worksheet Functions | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Linear Mode
