Cross-sheet formula

steve50951
steve50951 โœญโœญ
edited 12/09/19 in Formulas and Functions

I would like for sheet to auto populate certain fields based on entering in a "property name"

When I enter a property name, I would like for it to access the fields from another sheet that has that property name, and input values for that property.

would I use a =vlookup?ย 

Thanks for you help!

SGF

Screen Shot 2019-02-19 at 2.58.51 PM.png

Screen Shot 2019-02-19 at 2.59.32 PM.png

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!