Some facts about my dark spreadsheet past:
- I had learned to use VLOOKUP before.
- I had vowed to use VLOOKUP before.
- Whenever I had an opportunity to use VLOOKUP, I forgot how and didn’t want to spend the time or energy re-learning, so I just used a different formula or function.
But yesterday, I had an Excel task I couldn’t see an alternative solution for that wouldn’t require an hour of extra work, so I took the 5 minutes to re-learn how to use VLOOKUP yet again, and then I actually used it.
And it worked.