I have 2 sheets in 1 document. Sheet1 contains a lot of cities, each one has descriptive columns of the city, including City Name, Country, Population, etc. Sheet2 has a list of countries, and several descriptive columns of each country, including Population and GDP.
In the first sheet In column H, I want to calculate the % of population of each city, relative to the country. The way I would get this value is the following:
- Get the population of the city located in column C
- Find the row in Sheet 2 where Sheet1, column B equals Sheet2, column A
- Get the value of Sheet2, column B for the row obtained in previous step
- Divide the value of Sheet1, column C between the value obtained in previous step
Any ideas about the formula?