3 ms·

I can't agree with this when they've so recently added XLOOKUP https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929

by ziml77 4y ago

I can't agree with this when they've so recently added XLOOKUP https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 https://support.microsoft.com/en-us/office/xlookup-function-...

samplatt 4y ago
Unless that was sarcasm and I'm whooshing, I really don't get the big deal about xlookup. It's like vlookup but I'm no longer forced to have the lookup column as the first column in the range? I mean, that's nice, it makes my workflows one or steps shorter, but it's hardly groundbreaking.
- eisa01 4y ago
  What happens if you insert a column in the table you’re VLOKKUPING? It breaks :)
- ziml77 4y ago
  Mildly sarcastic. But it's much more sane than VLOOKUP which makes it feel like a big feature to people like me who always hated VLOOKUP.