Vlookup function in smartsheet dose not recognize the number value? But text worked?
Answers
-
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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thanks, I fixed by adding a ' to the number. I will try your method as well
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!