Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Replace multiples from a list
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 |
#2
|
|||
|
|||
"James" wrote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |