Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there a max number of columns that can be inserted in a sheet | Excel Discussion (Misc queries) | |||
Transpose: many columns to inserted rows | Excel Discussion (Misc queries) | |||
vlookup tables | Excel Discussion (Misc queries) | |||
vlookup on 3 different tables - please HELP | Excel Worksheet Functions | |||
Conditional formating: Compare two columns with Inserted lines | Excel Worksheet Functions |