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 |
#2
![]() |
|||
|
|||
![]()
Steps to make pivot table data compatible with VLOOKUP function:
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Take a look at some of the troubleshooting tips at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html#Trouble I bet that there are extra spaces (somewhere) or you have text masquerading as numbers. Louis wrote: 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 -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Louis
You need to use the GetPivotData function rather than VLOOKUP. Take a look at Debra Dalgleish's site http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Louis" wrote in message ... 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 |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Dave, Thanks that helps alot.
-- Louis "Dave Peterson" wrote: Take a look at some of the troubleshooting tips at Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html#Trouble I bet that there are extra spaces (somewhere) or you have text masquerading as numbers. Louis wrote: 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 -- Dave Peterson |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Roger,
Thanks, this works too. I never paid attention to the getpivotdata function before. -- Louis "Roger Govier" wrote: Hi Louis You need to use the GetPivotData function rather than VLOOKUP. Take a look at Debra Dalgleish's site http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Louis" wrote in message ... 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 |
Reply |
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) |