Broken Vlookup (No Match)

TAbs ✭✭
edited 03/09/23 in Formulas and Functions

My vlookup is returning no match even though there is a match avaliable.

But the reference sheet has an avaliable rate:



  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭


    Your Vlookup range contains both the SO # and the desired result, with the result being in the 2nd column, is that correct?

    Also, are both columns formatted the same way, and include no extra spaces / etc, that would be throwing the returned value off?

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

  • TAbs
    TAbs ✭✭

    Yes, they have the same info and are formatted the same way - no additional spaces.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @TAbs

    I notice that in one sheet for your matching values, your numbers appear on the right (indicating they're seen as numerical) whereas in the other sheet the numbers are displaying on the left side of the cell (indicating they're seen as text).

    Can you try translating the current sheet's number into a text value, to see if this then finds a match?

    =VLOOKUP([SO #]@row + "", {range...etc...



  • TAbs
    TAbs ✭✭

    Great, that worked!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!