Hi all,
The situation is that I have a master sheet, which is my overview sheet with the columns model, price supplier 1, price supplier 2, etc
sheet 2 is pricing from supplier 1 (model, price)
sheet 3 is pricing from supplier 2 (model, price)
I want to merge data from sheet 2 and 3 into the master sheet
Supplier data model name can differ per supplier, so my master sheet model name is a combination of all different supplier model names for that product together
There must be a partial match where the whole of supplier model names matches partially with my model name in the master sheet
Also the order of products per supplier is different.
What would be the best method in matching the supplier model name with any row in sheet 1 and fill out the supplier price in the supplier column in the master sheet?
Thanks for all the help.
Gijsbert
Bookmarks