How to join two sheets in same workbook with one common column of data - Excel 365 User

%3CLINGO-SUB%20id%3D%22lingo-sub-2273169%22%20slang%3D%22en-US%22%3EJoin%20to%20sheets%20in%20same%20workbook%20with%20one%20common%20column%20of%20data%20-%20Excel%20365%20User%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2273169%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20sheet%20has%207%20columns%20second%20sheet%20has%202%20columns%20sharing%20one%20common%20column%20only%2C%20that%20I%20must%20join%20into%20one%20table%20for%20analyzing%20results.%20Don't%20know%20how%20to%20join%20them%20%2F%20compare%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2273169%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

First sheet has 7 columns second sheet has 2 columns sharing one common column only, that I must join into one table for analyzing results. Don't know how to join them / compare?

1 Reply

@Ivette_Aquilino 

If to build separately new table with jined data Power Query shall work. If to add data from one table to another most probably ant lookup function as XLOOKUP, INDEX/MATCH, etc could work. All depends on concrete data structure.