oh ok, thanks.

im having a cell reference problem now... i have the pivot table of data copied over to the same worksheet but i cant seem to get the reference right in a vlookup.

ex. named range = a1:a19 = cats_1
B1=cats_1

=vlookup(C1,indirect(B1),2,false)