pivot table names

October 29, 2010 at 12:44:31
Specs: Windows 7
I am having trouble getting Vlookup to recognise my pivot table name as the table array in my formula. I don't want to just specify a tange of cells because I will be refreshing the pivot table every month, and sometimes some of the lookup values won't be present.I am using 2007
Any help welcomed!

See More: pivot table names

October 29, 2010 at 15:10:17
Did you know, that as I sit here at my desk, I can not see what your workbook looks like?

I don't know how your data is set up,
I have no clue as to what your vlookup formula reads,
nor do I know what your named ranges include or don't include
and the worst part is that my crystal ball is away for an upgrade this week and won't be back for several days.



Report •
Related Solutions

Ask Question