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