Forum Discussion

COMETMACE's avatar
COMETMACE
Copper Contributor
Jun 10, 2020

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

Resources