Forum Discussion

3 Replies

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Oct 23, 2024

    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")

     

     

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Oct 23, 2024

    DHurley 

    B1:B6 ist text that looks like numbers.

    A9 is a number.

    XLOOKUP() doesn't match numbers with text and vice versa.

     

Resources