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)),"N A",(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?

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 he

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


KarenABS wrote:
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)),"N A",(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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com