Vlookup function in smartsheet dose not recognize the number value? But text worked?

Options
Rachel Liang
Rachel Liang ✭✭
edited 11/29/22 in Formulas and Functions

See my Vlookup formula and output:

=VLOOKUP([Test Code]@row, {CTO Test List 2021 Range 2}, 3, 0)


When there is a text it worked, but not with the number i.e.139674 or 19041.1


Thanks for help!


image.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!