Hi:

I have a spreadsheet where thousands of individual unique product numbers are listed in rows. Each product row has one or more cells indicating the category (or categories) the product belongs to. This category information is numerical.

I have a second spreadsheet that has a list of the numerical categories with their corresponding text name. I want to convert the numerical categories in the first spreadsheet to their text names.

Example:


Spreadsheet #1

Product # Category 1 Category 2
12345 111 222
23456 333
34567 111 333
45678 222


Spreadsheet #2

Category # Category Name
111 Blue
222 Green
333 Red


What I am trying to create:

Product # Category 1 Category 2
12345 Blue Green
23456 Red
34567 Blue Red
45678 Green


Any ideas on how to accomplish this?

Thanks in advance.