Hi, I am doing a xlookup multiple criteria with boolean expression XLOOKUP(1,(B2=range 1)*(C2=range 2), range 3). However, the values in range 2 do not match all the time with C2 and I would like this part of the formula to look for a lower value in range 2 value provided the condition of range 1. Thanks a lot for the support!