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


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!