How to map two tables

Hello,

I have a first table of n rows (in the attached example, this first table has 14 rows)
Each item has a unique ID :
First table.png

Then, I have a 2nd table with less items (sometimes it is 25% less, sometimes it can be up to 90% less). Also, in this table, the rows have a different order than in the first table: they are all mixed up!
Furthermore, this table can contain new rows (which are not contained in the first table).
2nd table.png

I am (desperately) looking for a VBA script (or formulas?) to automatically make a "mapping" between these two tables, i.e. to add, in the first table, the price of each item from the second table (as long as the item from the second table was already present in the first table).

Anyone knows how to do that please? All help is welcome!

Thank you Richard for your answer. I have tried but I get this error message:
Attachment 767728

Here is the workbook. I have commented the formula you advised me to put in, otherwise it was not possible to save the file.

Could easily used PQ

Please Login or Register  to view this content.

Whoooo AMAZING! Richard's solution works... just perfectly! I have not tried the other ones since this one seems simpler to me.
Thanks everyone for your help!

5a6f313e480491b12cd39e27630a5e75.jpg