Forum Discussion
MATCH vs XMATCH: Binary Search to Find the Last Entry within a Range
I originally posted this as a response to this post, though thought it deserved a post in its own right. To reiterate: I believe that the new XMATCH function has one serious shortcoming which the...
I had the same idea but no time to check perf. against MATCH this morning
Just did it with 50K rows x 500 columns. From what I can visually observe MATCH still perform better (here)
Yes, MATCH has better performance, XMATCH has more options. What to use depends on concrete situation.