Huong L
The key is the column named "SPSmatch".
The SUMPRODUCT formula says in effect:
Look at the combination of "Supplier", "Product" and "Site"
at this row and find that combination on the other sheet,
then give me the row where you found it.
"MPrice" and "Mterms" use the row number
to find the rest of the data at the found row.
Advanced Filter whittles down the list to items
that do not match.