| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hlookup a value in a column and display the data 12 rows below. | Excel Worksheet Functions | |||
| Matching data from three columns (VLOOKUP, HLOOKUP, etc...)-URGENT | Excel Worksheet Functions | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| can i use hlookup to find data in another file | Excel Discussion (Misc queries) | |||
| Unable to sort data in excel with cells containing if & hlookup | Excel Worksheet Functions | |||
Threaded Mode
