Thread: Pivot Table as Source Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim May Jim May is offline
external usenet poster
  
Posts: 477
Default Pivot Table as Source Range
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
Reply With QuoteReply With Quote