In such cases, Excel's LOOKUP function can be extremely useful. It allows you to search for a value in a range of cells and ...

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. For example, if your vlookup ...