Forum Discussion
XLOOKUP Not Working
Why do none of the XLOOKUP functions on row 9 work? Microsoft® Excel for Mac 16.90.
B1:B6 ist text that looks like numbers.
A9 is a number.
XLOOKUP() doesn't match numbers with text and vice versa.
B1:B6 ist text that looks like numbers.
A9 is a number.
XLOOKUP() doesn't match numbers with text and vice versa.