efficiency365.com
Use PowerPivot instead of VLOOKUP - Efficiency 365
PowerPivot vs vlookup: VLOOKUP is the third most popular function in Excel. But it has its own limitations: large file size, slow performance, and lots of manual work.