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

Rachel Liang

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!

Mark Cronk

Try:

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

Mark

Rachel Liang

Thanks, I fixed by adding a ' to the number. I will try your method as well