4 ms·
Yes, I get what you mean. I was very happy to replace 90% of my use of convoluted EQUIV MATCH with XLOOKUP. Sometimes new functions are great. The point I want
by WastingMyTime89 4y ago
Yes, I get what you mean. I was very happy to replace 90% of my use of convoluted EQUIV MATCH with XLOOKUP. Sometimes new functions are great.
The point I wanted to make is that sometimes you can just get results quickly by some manual manipulation like sorting in complement to formula.