Hi
if you could explain your spreadsheet layout a little bit more there
may be alternatives. Honestly I can't think of a situation where I
would need 350,000 formulas in an Excel sheet. If an application
requires that much lookups Excel is probably not the right tool

--
Regards
Frank Kabel
Frankfurt, Germany


choice wrote:
i currently have multiple vlookups (about 350000), but there are only
about 10 a day that needs to be looked up...so i was wondering if
there was a way to use less equations or programming, this worksheet
is saved about every 2 minutes...so with all those equations it takes
a LOT longer to save