Forum Discussion
XMATCH Paradox
So I was 'playing' with some formula ideas and tried this one and got some paradoxical results. Can anyone explain what is happening? =XMATCH(1:1,1:1,,-1) So in this screenshot row 1...
Perhaps kind of bug in the exact XMATCH.
=XMATCH(A1:SR1, A1:SR1,,-1) works correctly, but =XMATCH(A1:SS1, A1:SS1,,-1) gave the same error as in the sample. I.e. when we exceed 512 vector size.
By the way, =XMATCH(1:1, 1:1 ,1 ,-1) have no such error and it looks like returns correct results.