3 ms·
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
by pavel_lishin 4mo ago
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.
- imurray 4mo agoI think you're thinking of "You Suck at Excel" by Joel Spolsky. https://www.youtube.com/watch?v=JxBg4sMusIg https://www.youtube.com/watch?v=JxBg4sMusIg Lots of past HN discussion... https://hn.algolia.com/?q=you+suck+at+excel https://hn.algolia.com/?q=you+suck+at+excel That video was before the introduction of xlookup, which I believe is now worth considering over index and match.
- pavel_lishin 4mo agoYes! Thank you!