Thread: Pivit Tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David A. David A. is offline
external usenet poster
 
Posts: 64
Default Pivit Tables

I have a vlookup that is searching a Pivot table. The proble is that every
morning the pivot table updates and adds a new column of data. This makes my
vlookup error out because its looking in the wrong column. How do I tell my
vlookup to look for a column with a heading OR tell it to look in the last
column with data in it?

Thanx,