I found it both amusing and annoying that the first line of the article mentions VLOOKUP.

In my experience, there's never a good reason to use VLOOKUP. You can always achieve the same functionality using INDEX (in conjunction with MATCH). Using VLOOKUP means that your formulae break as soon as someone inserts a new column in the middle of your table. And clicking the cell with the formula doesn't immediately show you which two columns are used by the function.

More (opinionated) Excel tips here: https://www.encona.com/posts/excel-best-practices