There was an excellent excel video by ... someone famous in our field whose name escapes me, and one thing I internalized from that was that VLOOKUP is always a bad choice, and INDEX + MATCH is almost always what you want instead.

About once a year I go looking for that video, and about half the time, I find it, and half the time I don't. I should really bookmark it.