Forum Discussion
COMETMACE
Jun 10, 2020Copper Contributor
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.
No RepliesBe the first to reply