Dear Excel Experts,
I'm currently in a pickle, as I have to manually compare hundreds of brand names (brand names also include product names) and materials, in order to see, if a references table with tens of thousands of brand names/product names and materials, contains any brand names and materials from a list that is refreshed on a week basis, or less often. However, luckily, I am not in a hurry to automate this, but it would be nice to be able to eventually automate this.
Typically the process involves searching each individual brand name, through excel's filter function, however if the brand/product name does not exist, I have to search for the material name, to see if at least the material is on the list. Regardless of whether or not I am searching for a brand or material name, I always have to make sure that the country codes from the list that refreshes match the county code from the reference table. So if I find the material and brand name, but the country code does not match, then I am not interested in the case Unique Identifier.
The actual reference table never changes and contains information that is presented in one of the following two ways:

So, if the list that I receive on a weekly bases, contains Brand1 and Material1 from Belgium (BE), then I would like to find all the Unique Identifiers associated with that Brand, Material and Country. When the brand/product name does not exist in the reference table or is not provided, I would like to find out, if the material and country at least exist together in the reference table. Basically, I would like to have my results similar to the following:

It is important that each Unique Identifier for the search terms is in its own seperate column and not its own seperate row. When searching for material and brand names, it is enough to search for the first few letters of the brand name or material, while the product name is not important.
I know this is asking a lot, so I do not expect to get the answer on a silver platter, but I welcome any help possible or any pointers in the right direction. Of course I will not be mad, if I do get the answer on a silver plate, but I do plan on becoming a VBA expert throughout the following so and so years.
Thank you for your time and consideration! Hope to eventually answer and not only ask questions!
Please let me know, if what I said makes sense, I have been told before that I have problems communicating problems!
Best regards,
SuperBerb
I'm currently in a pickle, as I have to manually compare hundreds of brand names (brand names also include product names) and materials, in order to see, if a references table with tens of thousands of brand names/product names and materials, contains any brand names and materials from a list that is refreshed on a week basis, or less often. However, luckily, I am not in a hurry to automate this, but it would be nice to be able to eventually automate this.
Typically the process involves searching each individual brand name, through excel's filter function, however if the brand/product name does not exist, I have to search for the material name, to see if at least the material is on the list. Regardless of whether or not I am searching for a brand or material name, I always have to make sure that the country codes from the list that refreshes match the county code from the reference table. So if I find the material and brand name, but the country code does not match, then I am not interested in the case Unique Identifier.
The actual reference table never changes and contains information that is presented in one of the following two ways:
So, if the list that I receive on a weekly bases, contains Brand1 and Material1 from Belgium (BE), then I would like to find all the Unique Identifiers associated with that Brand, Material and Country. When the brand/product name does not exist in the reference table or is not provided, I would like to find out, if the material and country at least exist together in the reference table. Basically, I would like to have my results similar to the following:
It is important that each Unique Identifier for the search terms is in its own seperate column and not its own seperate row. When searching for material and brand names, it is enough to search for the first few letters of the brand name or material, while the product name is not important.
I know this is asking a lot, so I do not expect to get the answer on a silver platter, but I welcome any help possible or any pointers in the right direction. Of course I will not be mad, if I do get the answer on a silver plate, but I do plan on becoming a VBA expert throughout the following so and so years.
Thank you for your time and consideration! Hope to eventually answer and not only ask questions!
Please let me know, if what I said makes sense, I have been told before that I have problems communicating problems!
Best regards,
SuperBerb
Comment