News for hackers. Stuff that matters.
Re:Excel is pretty dang cool by xupybd on Friday August 12, 2022 @07:07PM (#32445025)
Have you tried XLOOKUP?

I like it more than index match.

Re:Excel is pretty dang cool by jen729w on Friday August 12, 2022 @07:19PM (#32445117)
Well I work in an industry which still uses an archaic version of Excel. 2016 for Windows I guess? No XLOOKUP for me, yet. But yeah I’ll switch when it’s available.

INDEX(MATCH()) is clearly a janky hack. But once you get used to it, it works.