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)



"MK" wrote in message
...
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