export data to compare with some countries information

[damianozornetta]

Hello!

I'm new here and not so expert, i hope this is the right section to post my question.

I'll like to create an automatic sheet, that allow me for a product to define which country is the bigger consumer, the biggest consumer per square km, the best consumer per person.


I've a sheet with a list of all countries of the world containing the population, and area.
I download from statistics web-page a list of commercial-partner-country that consume this specific item (for example "water in 1.5 liters bottles").

example:

consumer country of water in 1.5 liters bottles:

Australia - 856
Austria - 900
Germany - 345
Italy - 123
USA - 1500
...

Now, once I've entered in my sheet all the list (not all countries are listed, only the one that use this specific product) I'll like to have on different sheets of the same files:
- a list of TOP consumer
- a list of TOP consumer per square km
- a list of TOP consumer per person

all with value.
My problem is that I've not idea how I can arrange this. Is it possible?
I mean it is not a problem to arrange the different calculation, but to "compare" and order the list of countries so that in one line will entered the value of population, area of the related country.

in the attached file "Workpage" I'm trying to get the "population" of the country in this Sheet from the "CountriesInfos" sheet.

I'm using the formula "DGET" but I'm doing somewhere an error.

Thanks.

damianoTEST.xls

Hello!

I'm new here and not so expert, i hope this is the right section to post my question.

I'll like to create an automatic sheet, that allow me for a product to define which country is the bigger consumer, the biggest consumer per square km, the best consumer per person.


I've a sheet with a list of all countries of the world containing the population, and area.
I download from statistics web-page a list of commercial-partner-country that consume this specific item (for example "water in 1.5 liters bottles").

example:

consumer country of water in 1.5 liters bottles:

Australia - 856
Austria - 900
Germany - 345
Italy - 123
USA - 1500
...

Now, once I've entered in my sheet all the list (not all countries are listed, only the one that use this specific product) I'll like to have on different sheets of the same files:
- a list of TOP consumer
- a list of TOP consumer per square km
- a list of TOP consumer per person

all with value.
My problem is that I've not idea how I can arrange this. Is it possible?
I mean it is not a problem to arrange the different calculation, but to "compare" and order the list of countries so that in one line will entered the value of population, area of the related country.

I hope it is clear what I mean, otherwise I'm here for further explanation.
Many thanks in advance to everybody can help me.
ciao
damiano

[humdingaling]

DGET does not work the way
i made it so it works on your example but i suggest you use this formula instead

=INDEX(CountriesInfos!B:B,MATCH(A3,CountriesInfos!A:A,0))

[damianozornetta]

Thanks a lot humdingaling!