Vlookup a cell with a formula
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
Check out the Formula Handbook template!