Reading excel file with very large set of Data

datatable
excel

#1

Hi,
I want to read an excel file that contains 200,000 + rows of records, spanning across 50 + columns.
I read in the forum that the number of rows can be split and the dataTable can read 10K rows at a time.
However I require to perform VLOOKUP on few columns from a file that is equally heavy. (200,000+ rows & 50+ columns).

Can someone suggest the approach to go about this problem?