Hi all,
I need some help with a rather specific problem; I've attempted myself and I'm not sure how to go about it, so any help would be greatly appreciated.
Basically I need to find replacement products whose attributes match exactly to the old products but also give a list of products that have a looser match. The exact match is, I think, relatively straight forward, it's the loose match that I'm stumped with. The loose match needs to find replacement products by exactly matching some core attributes but then any of the other attributes.
It's hard to explain, so please forgive me. I've attached a sample file as that might be easier:
- Sheet 'Full List' - Contains data on all products
- Sheet 'Replacement List' - The list of products for which replacement suggestions are need
- Sheet 'Found Replacements' - The replacement results; needs to contain the old product ID and attributes alongside the replacements (so the old product might be listed multiple times with different replacements)
Ideally, I want to be able to enter a list of IDs in the 'Replacement List' sheet and then run a macro. The results will then be presented in 'Found Replacements' where the old product ID and attributes are listed (columns A-K) alongside the replacements (columns L, N-W) and a match type (column M); so the old product might be listed multiple times with different replacements.
- For exact matches - The replacement attributes must match all of the old product attributes. The match type (column M in Found Replacements) is set to "Exact".
- For loose matches - The sheet 'Full List' contains all the product data, but I've also added notes about what attributes are required for the loose matches (attributes 1 and 2 must be matched for any of the loose matches). The match type is set to "Loose match".
- For loose matches (the ideal solution but if it's too hard then it's Ok to drop) - Same as above, all matches must meet the core attributes 1 and 2, but if a replacement matches 7 out of 8 of the remaining attributes then the match type is set to "loose match 1", if it matches on 6 out of 8 then it's "loose match 2" and so on.
I hope I've explained it enough, though probably not so if you are willing to try and help and have any questions I will answer quickly.
Thank you so much for at least reading my post, and if you do offer help then thank you even more! :D
Bookmarks