XLOOKUP($AN2,$AS$3:$AS$112,$BA$3:$BA$112,0,1,1)
example:
in an2 value 3
my serach value is {1,4,6,8,9,…}
my result value is {a,b,c,d,e…}
in excel its worked fine and result is : 4
but in libre result is : 0
If there are empty cells in the specified search range, it may be
tdf#167355.