Issues with VLOOKUP function

Hi,

I'm trying a formule using the VLOOKUP function and I have some troubles about the result:

When VLOOKUP searh for a text in a cell it works fine but if this cell has a number it doesn't work. However, if I put this number in the formule it wors fine.

Can you help me about this?

Thanks in advance.

Regards.


this is working:


not work:


Putting the number in formule, it works


Search table


Best Answers

  • Juan Carlos Reguera
    Answer ✓

    Hi,

    It work's fine.


    Thank you.

Answers

  • Hi, Genevieve P.

    Thank you very much for your answer.

    I've been testing, but it still doesn't work.

    I will prove to add a column formed by "sn + [Serial Number]" and I will tell you if it works. I hope so.


    Regards.

  • Juan Carlos Reguera
    Answer ✓

    Hi,

    It work's fine.


    Thank you.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi Juan,

    Glad you got it working!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!