I have a list of products in a Sheet, each product has several values that determine the final name.

For exemple :

• Product : familly, product type, resort
• SubProduct : familly, product type, resort and customer cateegory

I would like to use that list to import it in another system. For this i would like to create an unique ID for each product and subproduct using a number for exemple. If a product has the same setting (the ID should be the same) to be able to store them as subproduct from the product.

I hope i was clear in my problem.

I searched on google, but i think i have a lack of vocabulary in english to find exactly what i am looking for. I tried some formulas that i found but not working. Maybe you can help me in searching better or help me in proposing a formula ?

Thank you