Forum Discussion
MRendino
Dec 21, 2018Copper Contributor
Drop down list formula to change multiple cells
I created a drop down list of a few cities in Upstate, NY like: Buffalo, Rochester, & Syracuse and I have several rows of data that is listed as percent of revenue. I am trying to find a way so that ...
Ayman_Hassan
Dec 29, 2018MCT
I understand that you need the properties of each city to be filled automatically whenever the cell selected.
This depends on what type of data source you have and what info you need.
But generally, you have to ways to try and go through:
If the required info is fixed, you can attach them to the source of the drop down list, then use VLookup function to populate the data.
This is the solution that I think fits here.
Otherwise, if the required info comes from another raw data sheet, as summary for example, you can use a custom SUMIFS function, or one of it's siblings (Countifs, Averageifs,...) depends on whatever you need.
I attached a simple sheet to explain the first solution.