Forum Discussion
XLOOKUP Not Working
Why do none of the XLOOKUP functions on row 9 work? Microsoft® Excel for Mac 16.90.
DHurley To match a number with string (numbers stored as text into excel cells) covert that numbers to string before lookup. Try-
=XLOOKUP($A$9&"",$B$1:$B$6,$A$1:$A$6,"NotFound")Or convert those text into number then lookup.
=XLOOKUP($A$9,--$B$1:$B$6,$A$1:$A$6,"NotFound")
- That did it. Thanks.
