Automatically drawing data from another sheet? Vlookup? Index?

edited 03/27/23 in Formulas and Functions

Hi brainstrust,

I'm trying to match up some population data from a different sheet with a humanitarian response distribution tracker. So if a volunteer enters "Sydney" in a row regarding their latest trip then the population is automatically entered from the other sheet.

I've tried to use IF but there are way too many options (up to 200 locations). From a quick search here I see maybe Vlookup and Index could be options?

Any advice?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!