Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automating search and replace
I'm trying to do something simple, yet I can't figure it out.
I have two spreadsheet. One includes company names and "codes": QWE843 | Apple FER244 | Dell RWT224 | HP and so on. In another spreadsheet I have a list of people from each company, but instead of the company name, they have their company code: QWE843 | Joe Doe FER244 | Mary Monson QWE843 | Steve Jobs FER244 | Donald Duck What I'd like to do is to add a column with the company names in the second spreadsheet, taking the first spreadsheet as a reference. So, the end result would be QWE843 | Joe Doe | Apple FER244 | Mary Monson | Dell QWE843 | Steve Jobs | Apple FER244 | Donald Duck | Dell I tried with if, then, if, then... but it's too many parameters (there are about 300 different company codes). Is this doable? Thanks! M. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automating search and replace
Try this in column C of your second sheet:
=VLOOKUP(A1,Sheet1!A:B,2,0) and copy down for as many names as you have. Hope this helps. Pete On Oct 13, 3:26*pm, Wellman wrote: I'm trying to do something simple, yet I can't figure it out. I have two spreadsheet. One includes company names and "codes": QWE843 | Apple FER244 | Dell RWT224 | HP and so on. In another spreadsheet I have a list of people from each company, but instead of the company name, they have their company code: QWE843 | Joe Doe FER244 | Mary Monson QWE843 | Steve Jobs FER244 | Donald Duck What I'd like to do is to add a column with the company names in the second spreadsheet, taking the first spreadsheet as a reference. So, the end result would be QWE843 | Joe Doe | Apple FER244 | Mary Monson | Dell QWE843 | Steve Jobs | Apple FER244 | Donald Duck | Dell I tried with if, then, if, then... but it's too many parameters (there are about 300 different company codes). Is this doable? Thanks! M. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automating search and replace
Assuming the complete list in Sheet1 Col A & B
and the details in Sheet2 A-B then put this in Sheet 2 C1 and copy down =VLOOKUP(A1,Sheet1!A:B,2,false) -- To get my email id paste my address in an Excel cell and press Enter... "Wellman" wrote: I'm trying to do something simple, yet I can't figure it out. I have two spreadsheet. One includes company names and "codes": QWE843 | Apple FER244 | Dell RWT224 | HP and so on. In another spreadsheet I have a list of people from each company, but instead of the company name, they have their company code: QWE843 | Joe Doe FER244 | Mary Monson QWE843 | Steve Jobs FER244 | Donald Duck What I'd like to do is to add a column with the company names in the second spreadsheet, taking the first spreadsheet as a reference. So, the end result would be QWE843 | Joe Doe | Apple FER244 | Mary Monson | Dell QWE843 | Steve Jobs | Apple FER244 | Donald Duck | Dell I tried with if, then, if, then... but it's too many parameters (there are about 300 different company codes). Is this doable? Thanks! M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and replace | Excel Worksheet Functions | |||
Search and replace | Excel Discussion (Misc queries) | |||
Search and Replace | New Users to Excel | |||
Search and replace | Excel Worksheet Functions | |||
Search and replace | Excel Worksheet Functions |