Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP vs INDEX and MATCH | Excel Discussion (Misc queries) | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
Index Match Concatenate and Screen Size | Excel Worksheet Functions | |||
Vlookup or Index/Match | Excel Discussion (Misc queries) | |||
Vlookup, index, match? | Excel Worksheet Functions |