Problem with VLOOKUP and pivot table

L

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
 
R

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.
 
L

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 i
just returns NA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup with Pivot Table 1
PIvot Tables 2003 and VLookup 5
VLOOKUP Dates in a Pivot Table 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Issue with pivot table 1
Pivot Table - Changes 5
Pivot table not recognizing same field values 1
Group in Multiple Pivot table 1

Top