R
RJB
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...
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...