Aug 05 2022 04:41 PM
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!
Aug 05 2022 09:12 PM
@yoreally Depending on the Excel version you work with, you can use either VLOOKUP or XLOOKUP. Demonstrated both in the attached file.