Impact of many VLOOKUPs in a spreadsheet
 

Hi - I have a financial data spreadsheet with hundreds of vlookups. As the
spreadsheet grows over time, is there any way of knowing what the resource
impact will be with that many vlookups? I don't want to risk crashing the
spreadsheet.
--
TIA
Chuck M.

Impact of many VLOOKUPs in a spreadsheet
 

There are many variables that interact and that make it difficult to assess:
are the lookup tables huge? are you doing exact lookups? are the lookups
daisy-changed? what other complexities exist?

When you look at this model, should any of these lookups for past periods be
converted to static values?

"Chuck M" wrote:

Hi - I have a financial data spreadsheet with hundreds of vlookups. As the
spreadsheet grows over time, is there any way of knowing what the resource
impact will be with that many vlookups? I don't want to risk crashing the
spreadsheet.
--
TIA
Chuck M.

Impact of many VLOOKUPs in a spreadsheet
 

Thanks for the reply. The 2 largest lookup tables are 26x500. All lookups
are exact. A few are daisy-chained. You bring up a good point. Quite a few
of the lookups are for prior periods can be converted to static values. That
should help quite a bit.

Thanks for pointing me in that direction!!
--

Chuck M.


"Duke Carey" wrote:

There are many variables that interact and that make it difficult to assess:
are the lookup tables huge? are you doing exact lookups? are the lookups
daisy-changed? what other complexities exist?

When you look at this model, should any of these lookups for past periods be
converted to static values?

"Chuck M" wrote:

Hi - I have a financial data spreadsheet with hundreds of vlookups. As the
spreadsheet grows over time, is there any way of knowing what the resource
impact will be with that many vlookups? I don't want to risk crashing the
spreadsheet.
--
TIA
Chuck M.