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!

Get pivot data / V/Hlookup
 

In article , ?B?
UGlsYXIgTW9yYWxlcw==?= wrote:

Does VLOOKUP work on a pivot table with relative references vs. actual values?


Probably - not tried it, but if you're getting a #REF! on the pivot table you'll
probably get a #N/A! error from the VLOOKUP.

This formula gets a #REF! result:

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


That'll be because either H7 or A13 contains a value not in the Pivot Table.

Try putting the GETPIVOT function inside an IF(ISERROR() function, e.g.:

=IF(ISERROR(GETPIVOTDATA(....)),0,GETPIVOTDATA(... .))

which will provide a 0 if the row or column header doesn't exist (which is
probably what is causing the #REF! Error).

--
Spence
Computing Services - because IT needn't be difficult
http://www.compservonline.co.uk/