Autopopulate multiple columns based on the selection of one drop down?

I'm creating a Form for my end users and would like to pull back information on specific stores. I have 246 stores with addresses. I have these columns that will need to populate data based on the option selected in the Store # (Drop Down):

Like I said above, I have 246 different stores that will each have their Store Names, Addresses, etc. so a NestedIF statement will be very lengthy. What is the best approach to building this out on either the sheet itself or through using Logic when building a Form?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!