I need to create a matrix where I can visually identify which are the prices of the same product from different providers using Microsoft Excel. My providers send me a list of products monthly, so I miss a lot of time building a cross-reference list of prices to check where is it cheaper and where to buy if it gets out of stock in the first option store.
Please consider that each provider has a different description for the same product.
For example, if a product is "Acqua di Gio for men 100 ml", maybe another provider list may say "acqua gio man EDT 100ml".
Lists come both in excel and pdf format.
Final file should look like attached pic.