Attachment 581878
Hi Everyone!
Can You Help me. I run store and i want to categories my product base on product id in to four age groups. I have manually created desired output in column "E".
is there any way to get same result in "D" with any formula? Product ID are same for different Sizes. Main is product and Sub are different sizes.
Same product has different sizes which fits to that categories,
I have applied vlookup for that and past special.
age 1-2 : Kid
age 2-7 : Toddler (This Product Goes In KID and Toddler )
age 6-11: Younger Kid (This Product goes in Toddler and Older Kid.)
age 10-16 : Older Kid.
I have Attach the file and Image.
This is a sample file. Original file contains 5000 Product IDs.
Bookmarks