Xlookup between two tables

[kapela2017]

Greetings, I would be very grateful if you could give me some idea, you will see I am trying to develop a code that allows me, through a macro, to apply the XLookUp function to compare two tables (TABLE1 AND TABLE1) and enter, according to their ID, the weight and the cost of the products in the second table and after leaving the "TABLE1" clean to be filled again,((𝐓𝐀𝐁𝐋𝐄𝐒 𝐂𝐀𝐍 𝐆𝐑𝐎𝐖 𝐎𝐍 𝐈𝐃 𝐂𝐎𝐃𝐄 𝐅𝐎𝐑 𝐏𝐑𝐎𝐃𝐔𝐂𝐓𝐒)) I'm starting with Vba and I can't get much further than the Dim and the Set, I'm trying to declare the function with Listobjects.ListColumns. DataBody.Range and the function does not accept the range thanks for what you can contribute... ID PRODUCT WEIGHT COST 1001 APPLE 0,2 KG 2,3$ 1002 PEAR 4,5 KG 3,1$ 1003 PEACH 5,4 KG 2,1$ 1004 STRAWBERRY 2,9 KG 3,4$ 1005 CANTAOLUPE 4,9 KG 4,1$ 1006 MANGO 2,4 KG 3,2$ 1007 ORANGE 5,9 KG 1,4$ 1008 BANANA 8,5 KG 3,2$ ID PRODUCT WEIGHT COST 1001 APPLE 0,2 KG 2,3$ 1002 PEAR 1003 PEACH 1004 STRAWBERRY