LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Inserted Columns into VLOOKUP Tables

So I have a whole bunch of tables that are summarized in a few
presentation charts by using massive amounts of VLOOKUPs.

It's the 11th hour - I'm taking the charts to the printer.

I've discovered that if I insert a column to the ORIGINAL chart, the
VLOOKUP does not float...

In other words:

On "Original Chart", I have columns A-C, Customer, Region, Sales.
On "Presentation Chart", I have VLOOKUP (A1, Original Chart, 3,
false). So that returns "Sales".

Now, we've added stuff to "Original Chart": Now it's, A-E, Customer,
Sales Manager, Region, Phone Number, Sales.

Now, when I load "Presentation Chart", the lookup returns "Region"...
It didn't 'push' the lookup to float with "Sales".

Is there any way to resolve? They're not all so simple, some are
"Margins" and "Revised Margins", so a quick scan won't pass the BS
test to figure out if/where my data went funny.

Uh-oh...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Is there a max number of columns that can be inserted in a sheet Monja Excel Discussion (Misc queries) 3 June 17th 08 01:21 PM
Transpose: many columns to inserted rows JanR Excel Discussion (Misc queries) 0 January 15th 08 03:52 PM
vlookup tables april Excel Discussion (Misc queries) 2 January 3rd 08 04:11 PM
vlookup on 3 different tables - please HELP Nir Excel Worksheet Functions 3 October 30th 06 02:54 PM
Conditional formating: Compare two columns with Inserted lines Tim Excel Worksheet Functions 1 September 12th 06 03:34 AM


All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"