excel - Faster way to VLOOKUP huge set of data -
in workbook, have sheet huge set of info around 7 lacs. have 2 columns in sheet. lets workbook wk-a
this huge info used me on daily basis vlookup. issue vlookup takes lot of time , opening wk-a takes lot of time.
there's no formula on wk-a, contains plain text data.
moreover, not doing vlookup in single cell in sec workbook. have 30000+ records trying info first workbook. , taking lot of time.
i have tried vlookup kepping first workbook closed open, no much effect in time.
can suggest faster way vlookup these huge data???
you can sort wk-a , utilize double vlookup trick (assuming want know if there no matching record in wk-a).
for details of double lookup trick see http://fastexcel.wordpress.com/2012/03/29/vlookup-tricks-why-2-vlookups-are-better-than-1-vlookup/
but excel limit 1 1000000 rows.
excel excel-formula
No comments:
Post a Comment