Combining different lists

Sorry if this is a newbie question, but…

I have a single spreadsheet containing several worksheets.

On each worksheet is a table of countries, along with data gathered from different sources.

So for example, on worksheet 1, I have a list of countries by per capita GDP from the world bank. On worksheet 2, I have a list of countries by disposable income from the OECD.

The problem is, these lists of countries aren’t exactly the same. The World Bank list might have 156 countries, but the OECD list might have 175 countries.

Is there a way to combine these different sources into a single list? e.g. I want to have a master table of countries with both per capita GDP and disposable income.

Originally Posted by AliGW

Yes. Set up the full list of countries on the new sheet and your column headings, then simply use VLOOKUP or INDEX MATCH to bring the relevant data into it.

Thanks for the reply!

Can you be more detailed? I'm not really familiar with the VLOOKUP or INDEX MATCH functions.

For example, I have uploaded an excel spreadsheet that contains 2 lists. Can you create a new list that combines these 2?