Apr 14 2021 12:41 PM - edited Apr 14 2021 12:42 PM
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?
Apr 14 2021 01:26 PM
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.