Vlookup with Pivot Table

[KarenABS]

I have a pivot table that I need to use a Vlookup with but I get the wrong
answer. I have seen a function like
=IF(ISNA(VLOOKUP(G18,LookUp!$A$1:$B$8,2,FALSE)),"NA",(VLOOKUP(G18,LookUp!$A$1:$B$8,2,FALSE)))
work with a pivot table but I cannot get it to work I always get NA. I can
get it to work outside of the pivot table but not inside. I know that there
are some limitations with pivot tables but others have gotten it to work so I
must be missing something.

Is there a way to upload the spreadsheet here?

 

[Debra Dalgleish]

Headings aren't in every row of the pivot table, so you might have
trouble doing a lookup.

Instead, you could try a GetPivotData formula, to pull specific data
from the pivot table. There's information and a few examples here:

http://www.contextures.com/xlPivot06.html