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

Options

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!



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!