VLOOKUP Table Array - How to use PivotTableName?

[dmagnus]

I'm using Excel 2010. I've searched the forum but can't find what I think is a simple answer. I'm creating a VLOOKUP against a pivot table and I want to avoid having to change the Table_Array's range when new data is added to the pivot table. So I created a name for the PivotTable (ABC_Data).

Now I'm trying to use the name "ABC_Data" in the VLOOKUP's Table_Array field...but the result of the VLOOKUP is #NAME?. Apparently the formula doesn't like the PivotTable name. What am I missing here? I've successfully used TableNames in VLOOKUPs...can't I use a PivotTableName?

Thanks in advance for your help!