Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My vlookup doesnt' work if I am looking up data that are in the results of a
pivot table. If I hand type the pivot table results to a new sheet it will work but if I tried to re-format the pivot table results or copy the results as values and it won't work. It will only work if I hand type the data. With almost a thousand results in the pivot table, to continue to do this isn't practical. What do I have to do to make the pivot table data results compatible with the vlookup function? -- Louis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - divide two results | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Table for survey results with set of possible answers in PT's Rows Field? | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |