You can do a lot in Microsoft Excel and Google Sheets, beyond the obvious spreadsheet-style organization and data collating. A lot of this is tied to both of their programming-like functions that ...

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.