Thread: Get pivot data / V/Hlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pilar Morales Pilar Morales is offline
external usenet poster
  
Posts: 8
Default Get pivot data / V/Hlookup
Does VLOOKUP work on a pivot table with relative references vs. actual values?

This formula gets a #REF! result:

=GETPIVOTDATA("Quantity",'YTDHrsbyEmployee (2)'!$B$11,"Calendar
Year/Week",H7,"Employee",A13)

Thanks!
Reply With QuoteReply With Quote