Forum Discussion
Zenstone65
Aug 06, 2020Copper Contributor
Excel: Inserting values from one table into another based on a primary key relationship
Hi So I have two excel sheets or tables , Donor and Gift , 1 Doner may give 0-M Gifts, the two tables are linked by email address which is unique in the Donor Table. I want to add Name from the D...
SergeiBaklan
Aug 06, 2020Diamond Contributor
If that's for Excel Table you may use INDEX/MATCH or XLOOKUP or like.
If in data model table with PowerPivot you may use RELATED().
If Power Query table you may merge.
What is the scenario?