vlookup on pivot table results = #N/A

[Louis]

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?

 

[Dave Peterson]

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.

 

[Roger Govier]

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

 

[Louis]

Dave, Thanks that helps alot.
--
Louis

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]

Roger,
Thanks, this works too. I never paid attention to the getpivotdata function
before.