Hello,

I have a list of categories in one column incrementally numbered in the next
column, and on another sheet I have the same categories listed with different
products.

In the sheet with products, I want to replace each instance of the category
name with it's corresponding number from the first list.

Yes - I can simply use Find/Replace for each category, but this would take a
long time with all the information, so I'd rather build a function (VLOOKUP?)
to do it all at once.

Any ideas would be greatly appreciated