XLOOKUP returns results inconsistently

Occasional Visitor

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.

 

Screen Shot 2020-06-10 at 8.14.23 AM.pngScreen Shot 2020-06-10 at 8.19.49 AM.png

0 Replies