3 ms·
Have you tried XLOOKUP? I like it more than index match.
by xupybd 4y ago
Have you tried XLOOKUP?
I like it more than index match.
- jen729w 4y agoWell 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.