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.
Thanks, saving a click, not going for the article; not that it's necessarily bad or uninteresting; not that I wouldn't if I had more time on this planet.
Rendered at 19:53:25 GMT+0000 (Coordinated Universal Time) with Vercel.
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.
Lots of past HN discussion... 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.
Is support poor? Competitors can do it: https://www.quadratichq.com/ (look at their VLOOKUP example)
Thanks, saving a click, not going for the article; not that it's necessarily bad or uninteresting; not that I wouldn't if I had more time on this planet.