Vlookup a cell with a formula


Hello everyone,

I am trying to use a normal Vlookup function in smartsheet. The search_value (number) and also the value that is supposed to be looked up in the look_up table (same number) are also pulled with other formulas. If I hardcode the numbers instead of suing a formula, then the Vlookup works. Does this mean that in smartsheet you can´t vlookup a search_value that is also pulled from a fomrula?

Many thanks for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!