CFO.com article: Handle Growing Lookup Tables with a Two-Key Combo

CFO Magazine offers a solution for growing pivot tables.

…If you need to add new rows to the lookup table, the obvious place is to type the new rows in X8:Z9. However, these rows are outside of the lookup table, so you must re-enter the existing VLOOKUP formulas…. Read complete article at CFO.com

About Bill Jelen

Author of 41 books about Microsoft Excel. View all posts by Bill Jelen

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: