Vlookup a cell with a formula

Options

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!

Dennis


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!