i have 2 tables. 1st is the master list that contains all the part numbers. 2nd is the scrap data table that has scrap data for all the part numbers. now both the tables have part number as the common field but the problem is in both the tables the part numbers are exported from different excels although its the same part numbers. i want to have a column in the master list table showing total scrap cost for that part number, the value for which can be taken from the scrap data table. I am not ale to figure out how to do that.