Warning: This post assumes you know the basics of Excel VLOOKUP.
By default, Excel automatically re-calculates formulas in the spreadsheet.
Problem is if you have a VLOOKUP against 100k+ rows, it's gonna be a long day for you at the office.
Here's how to fix that.
