Your formula syntax may be correct, but XLOOKUP still cannot find an exact match. This usually happens because something in the lookup value or the data is slightly different from what it appears to be.
Choose one of the causes below, then click Run to see how the formula works on the grid and why the result goes wrong.
=XLOOKUP(104, A1:A6, C1:C6)Loading the interactive example…