From the source data table

I’m trying to compare 2 tables cell by cell, and what I want to achieve is getting ‘#N/A’ (using XLOOKUP function) in every cell that differs from the first table.

So, I have a Product that is made of multiple materials, labeled with material IDs. I need to pull the multiple material IDs from the cell and find their associated costs from another table, and then sum them all up to find the total production cost. This is easy to do when there is only one material needed for the product with a simple xlookup, however when there are multiple material IDs it doesn’t work. This is for a little made up project where I’m starting a business selling jewelry. I apologize if the answer is very simple, I am not an Excel expert. Anyhow the help is appreciated, thank you!