Forum Discussion
two lists to combine - column A similar list but one is longer and column B is different on each
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...
yoreally Depending on the Excel version you work with, you can use either VLOOKUP or XLOOKUP. Demonstrated both in the attached file.