Here i have explained how to apply Vlookup on 7000 Entries in Excel. i have given 2 examples to explain the Vlookup formula properly, and 2 more formulas is explained in the video that is Column() formula and Row() form, which helps a lot to apply Vlookup on large data in Excel.
Tutorial Video