Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup on pivot table results = #N/A
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
|
|||
|
|||
Answer: vlookup on pivot table results = #N/A
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
|
|||
|
|||
vlookup on pivot table results = #N/A
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
|
|||
|
|||
vlookup on pivot table results = #N/A
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
|
|||
|
|||
vlookup on pivot table results = #N/A
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
|
|||
|
|||
vlookup on pivot table results = #N/A
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 | |
|
|
Similar Threads | ||||
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) |