ExcelBanter - Compare product prices from two supliers and produce report

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Compare product prices from two supliers and produce report (https://www.excelbanter.com/excel-worksheet-functions/93046-compare-product-prices-two-supliers-produce-report.html)

[email protected]

Compare product prices from two supliers and produce report

Merged Sample data from two scources. I just pasted in the second supplier
below the 1st supplier info.
Product No Price
4556 100
5000 200
5001 300
4556 250

I have a list of 500+ items. I need to match the product Numbers then find
the difference in price from two suppliers

All times are GMT +1. The time now is 10:32 PM.