View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MK MK is offline
external usenet poster
 
Posts: 57
Default 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