2 ms·
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
by rahimnathwani 7y ago
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 https://www.encona.com/posts/excel-best-practices
- samdfonseca 7y agoSo you just decided you were gonna find something to criticize before you even clicked the link, eh?
- rahimnathwani 7y agoYup. Without clicking the link I correctly guessed that the first sentence mentioned VLOOKUP /s
- drej 7y agoThat is unless you parametrise that column index as well - you can do a MATCH to retrieve your desired column number and safeguard it against column insertions/deletions. (It weakens the case for VLOOKUP, but being quite a light Excel user, this is usually how I do things.)