Forum Discussion
Issues with Reverse Search in XMATCH
Hello - I have an application for which I am trying to utilize XMATCH's reverse function. Unfortunately I get the formula returns the same value regardless of whether the search mode argument is ent...
May be it is because the value you are searching is in the reference list As per syntax Exact match or next smaller item and Exact match or next larger item. "Exact Match" gives same.