Excel's VLOOKUP function lets you find data in columns in reference to the first column. Learn how to create it manually or build it easily.

Vlookup used to create an array in memory that held the full range of the table. So the smaller you can make the array, the less memory the function will use.