User Profile
COMETMACE
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
XLOOKUP returns results inconsistently
I'm getting inconsistent results for the search-mode parameter of the XLOOKUP function. Depending on the value that I'm searching for, I will either get the expected search-mode 1 or search-mode 2 results and for other values I get incorrect results. Here's screen captures: When "t" is searched, it shows correct results. When "o" is searched, it doesn't find the bottom value as expected. It finds the top value.
