Since a pivot table does not repeat the heading values down the columns you
are not going to have a lot of luck using the pivot table as the source for a
vlookup. Perhaps a better explanation of what you are trying to do would
help. A sumproduct formula directed against the source data for the pivot
table might be a better option.
--
HTH...

Jim Thomlinson


"Jim May" wrote:

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