Pivit Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
If you search for a heading, use a VLOOKUP that has many columns in
the 2nd argument.

=VLOOKUP(value,A:Z,MATCH(heading,A1:Z1,0),0)

For the last column:

=VLOOKUP(value,A:Z,COUNTA(A1:Z1),0)

HTH
Kostis Vezerides
 
Back
Top