Vlookup to another workbook file size

[papasmurfuo9]

Hi i have a 20kb workbook,

i need to vlookup into another workbook, however this workbook is 27mb (with A-F, 500,000 rows)
when i put my vlookup in the 20kb workbook,the file size jumps up too 27mb

anyway way to stop this?

=VLOOKUP(D4,'Account List.xlsm'!$A$1:$F$548222,2,FALSE)

many thanks

[Tony Valko]

=VLOOKUP(D4,'Account List.xlsm'!$A$1:$F$548222,2,FALSE)

Don't know if this will make any difference or not...

The lookup table is 6 columns wide but you only need to reference 2 since you're pulling the result from column B.

=VLOOKUP(D4,'Account List.xlsm'!$A$1:$B$548222,2,0)

[papasmurfuo9]

thanks for the reply, it helps, but not majorly, im not at 16mb, any other suggestions?
thanks

[Tony Valko]

See if this makes a difference:

=INDEX('Account List.xlsm'!$B$1:$B$548222,MATCH(D4,'Account List.xlsm'!$A$1:$A$548222,0))

[papasmurfuo9]

thank you
its 9MB now. getting there

[Tony Valko]

Another thing that can adversely effect file size is the used range.

See this:

http://www.contextures.com/xlfaqApp.html#Unused