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?
Help Article Resources
Check out the Formula Handbook template!