| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table as Source Range
Hi Jim
Take a look at the GetPivotData function. More help can be found at Debra Dalgleish's site http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Jim May" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Efficient Source Range | Excel Discussion (Misc queries) | |||
| Using cursor keys to select Pivot Table Source Data Range | Excel Discussion (Misc queries) | |||
| Pivot Table Source Worksheet and Range | Excel Discussion (Misc queries) | |||
| Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
![Roger Govier[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
