4 ms·
very nice I had been a big vlookup fan until I upgraded excel versions and fell in love with xlookup
by smashy9 3y ago
very nice
I had been a big vlookup fan until I upgraded excel versions and fell in love with xlookup
- seanhunter 3y agoAbsolutely. And of course when you start playing with xlookup you learn that "you cannot change part of an array". If you know, you know.
- andelink 3y agoIs xlookup new? I’m not familiar with it. I used excel quite a bit back in 2015/2016
- _dain_ 3y agoYeah it's new. Excel is a whole different animal now than in 2016. LET, LAMBDA, and spill arrays completely change how you do things.