Use of Vlookup vs Index-Match (workbook size)

M

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
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel File Size 9
Dynamic Index() or Vlookup() 1
Vlookup, Index & Match 1
VLOOKUP, MATCH, INDEX Result? 2
Calculation Speed (Index/Match vs Vlookup)? 6
Vlookup - Match - Index 2
Index & match vs vlookup 11
OFFSET vs INDEX(MATCH(...)) 1

Top