I have two sheets, one containing categories the other containing products.
Example for sheet1 - Contains category and cat number
Widgets 1
Red Widgets 2
Blue Widgets 3
Sheet2 - Contains products and product category
1oz Widget 1 2 3
2oz Widget 4 5 6
In this example the 1oz widget belongs to category 1, 2 and 3 the 2oz widget belongs to category 4, 5 and 6. What I would like to do is replace the category number in sheet 2 with the text. So 1oz widget would become 1oz Widget - Widgets
The description and numbers are in seperate columns. Sheet 2 contains up to 3 categories for each product.
So what I would like to do is replace the category number in the sheet2 with the name in category 1.
Any help would be greatly appreciated because this will save me a LOT of time.
Thanks for reading!
Jim