Replace multiples from a list

[Guest]

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

 

[Guest]

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

OK insert a new column on your second sheet, then put a formula similar to
this in the first cell (sheet name as yours is named)
=VLOOKUP(A1,Sheet1!$A$1:$B$5,2)
then copy the formula down the column as many times as is required.