Problem with VLOOKUP and pivot table

[LB79]

Hello - Im having a problem. Im trying to use VLOOKUP to read a cell from a pivot table then return a value from another non pivot table on another sheet. Only trouble is it always returns NA. Ive checked the VLOOKUP formular and it works so it must be a problem reading the pivot field.
Can anyone help?

Thanks

[robert111]

I just made a test spreadsheet with pivot table and lookup table, and I can use cells from the pivot table to bring back a value from a lookup table, so you must have an error in your formula??? Send us your actual formula.

[LB79]

The formula im using is

=VLOOKUP(C5,$A$2:$B$50,2)

If I type actual data into C5 then it works, but if its pivot data it just returns NA.