Use of Vlookup vs Index-Match (workbook size)

[MK]

Hi,

I have a 118 MB workbook of which I'm trying to reduce the size. It contains
a lot of Vlookup functions, and I was thinking of using index+match instead.
Would that help? How about Offset? Does a

What other things (apart from the vast amounts of data) are the main reasons
a workbook gets oversized? Queries? Use of nametags (arrays) in formulas?
Macros?

thanks,

Martha K

 

[Bob Phillips]

In an 118 Mb workbook? I doubt it. You have to break down what is causing
that monster size and design a strategy for that, changing VLOOKUP for
INDEX/MATCH is fiddling while Rome burns.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)