VLOOKUP numbers in PivotTable resulting in #NA

[kpinnock611]

Hello,

I am trying to VLOOKUP numbers from 0:99 that are in a PivotTable, however I getting the #NA result when I know there are values to be found. I have tried converting the original data and the pivot table data to numbers, but I still can't seem to make it work.

[kpinnock611]

I realized that I could simply use the SUMIF formula.