Impact of many VLOOKUPs in a spreadsheet

[Chuck M]

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.

 

[Duke Carey]

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]

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!!