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)
Bookmarks