two lists to combine - column A similar list but one is longer and column B is different on each

Copper Contributor

So I have two sheets

 

sheet 1:  a list of countries (100) in column A and their region in column B

 

sheet 2: a list of countries (60) in column A and their GDP in column B

 

I want to combine those lists retaining the related information for each country, so I would end up with one sheet that has column A as countries, column B as region and column C as GDP.

 

I suspect this is easy, but I just can't find something on the web.

 

Thank you!

1 Reply

@yoreally Depending on the Excel version you work with, you can use either VLOOKUP or XLOOKUP. Demonstrated both in the attached file.