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

Question

So I have two sheets&nbsp;sheet 1:&nbsp; a list of countries (100) in column A and their region in column B&nbsp;sheet 2: a list of countries (60) in column A and their GDP in column B&nbsp;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.&nbsp;I suspect this is easy, but I just can't find something on the web.&nbsp;Thank you!

riny_van_eekelen · Answer

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

Forum Discussion

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

Share

Resources