Posted to microsoft.public.excel.worksheet.functions

David A.

external usenet poster

Posts: 64

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,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
some tables	hosni	Excel Discussion (Misc queries)	3	March 1st 07 05:38 PM
Pivit table not displaying data	Gimp	Excel Discussion (Misc queries)	3	February 6th 07 10:33 PM
tables	Sam	New Users to Excel	2	January 14th 07 05:32 PM
Which Tax Tables to use?	[email protected]	Excel Discussion (Misc queries)	6	July 8th 06 05:19 PM
pivit table will not caculate	Mike	Excel Discussion (Misc queries)	1	March 28th 05 10:57 PM

All times are GMT +1. The time now is 03:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us