Use of Vlookup vs Index-Match (workbook size)
 

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

Use of Vlookup vs Index-Match (workbook size)
 

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

Use of Vlookup vs Index-Match (workbook size)
 

The usual reason for oversized workbooks is excess used range: check what
Excel thinks is the last used cell on each worksheet using Control End, and
remove any excess using Clear and/or Delete.

Of course the size of a workbook is not usually much of a problem, its the
calculation time, and slow calculation is not usually caused by workbook
size.

For a discussion on how to speed up Lookups and using Index/Match versus
Vlookup see
http://www.decisionmodels.com/optspeede.htm

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"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

Use of Vlookup vs Index-Match (workbook size)
 

Thanks a lot, I'll have a look!

In my opinion the database I am working on should have been constructed in
Access (or similar). There are loose plans of restructuring, but until that
happens (as Excel is the main program used in the company, and people are not
too keen on changing that) I'll simply have to "fiddle while Rome burns" and
change what I can.


"Charles Williams" wrote:

The usual reason for oversized workbooks is excess used range: check what
Excel thinks is the last used cell on each worksheet using Control End, and
remove any excess using Clear and/or Delete.

Of course the size of a workbook is not usually much of a problem, its the
calculation time, and slow calculation is not usually caused by workbook
size.

For a discussion on how to speed up Lookups and using Index/Match versus
Vlookup see
http://www.decisionmodels.com/optspeede.htm

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"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