Hi Jim

Take a look at the GetPivotData function.
More help can be found at Debra Dalgleish's site
http://www.contextures.com/xlPivot06.html

--

Regards
Roger Govier

"Jim May" wrote in message
...
I just tried using a Pivot table in a Vlookup() and it doesn't seem to
work.

=Vlookup(A1,MyPivottableRange,2)

Can someone confirm or inform me otherwise?

TIA