I have a list of products that are extracted from our order system. These products have a category name in the order system which is located in K2. However in our planning sheet we are using less categories than there are and are grouping certain "sub categories" and I wanted to automatically change the values to the correct value. The relation between values is as following:
On my "Lookups" sheet I have a table where VALUE in column 1 needs to be converted to VALUE in column 2 on the main sheet. I have a list of products with their correct replacement.
For instance; Scarves, belts , headwear etc need to become Accessories. Trousers need to become Pants. But the VALUES that do not need to be replaced I will let the formula pass and use the original value in K2.
I have made a rudimental formula that works but I'm worried it might slow down the file too much. If anyone has a better option then please enlighten me. This is the formula I currently use:
=IF(K2="Underwear","Accessories",IF(K2="Other Accessories","Accessories",
IF(K2="Socks","Accessories",
IF(K2="Belts","Accessories",
IF(K2="Headwear","Accessories",
IF(K2="Bags","Accessories",
IF(K2="Scarves","Accessories",
IF(K2="Footwear","Shoes",
IF(K2="Trousers","Pants",
IF(K2="Sweatshirt","Sweat",K2))))))))))
So if I can replace value with set value in my lookups sheet then that would be easier. Perhaps that is a function i do not know about yet.
Bookmarks