| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Perform a "Conditional Substitute/Replace"
I have two worksheets:
1st wksht has raw data including one column with users' unix IDs 2nd wksht has users' full names After adding a new column to the right of the unix ID column, I want to search for every occurrence of each user's unix ID (in the 1st wksht) and place the user's full name (from the 2nd wksht) into the new column on the right (for instance: Sheet1 unix id="brubble" Sheet2 unix id="Barney Rubble (brubble)" After adding new column to right of Sheet1 unix id="brubble", function searches Sheet2 and every row that contains "brubble" will have "Barney Rubble (brubble)" placed in cell immediately to the right. Hope this makes sense. BTW, using Excel 2003 on a Windows 2000 platform -- Thanks! Bay Area DebG |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Perform a "Conditional Substitute/Replace"
If I understand correctly, the ID in Sheet1 is embedded in the ID name in
Sheet2 i.e in the brackets and not in a separate column If this is correct try putting this in B2 in Sheet1 and copy down: =VLOOKUP("*" & A2&"*",Sheet2!A:A,1,FALSE) It assumes IDs & ID names are in column A on both sheets. HTH "Bay Area DebG" wrote: I have two worksheets: 1st wksht has raw data including one column with users' unix IDs 2nd wksht has users' full names After adding a new column to the right of the unix ID column, I want to search for every occurrence of each user's unix ID (in the 1st wksht) and place the user's full name (from the 2nd wksht) into the new column on the right (for instance: Sheet1 unix id="brubble" Sheet2 unix id="Barney Rubble (brubble)" After adding new column to right of Sheet1 unix id="brubble", function searches Sheet2 and every row that contains "brubble" will have "Barney Rubble (brubble)" placed in cell immediately to the right. Hope this makes sense. BTW, using Excel 2003 on a Windows 2000 platform -- Thanks! Bay Area DebG |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Perform a "Conditional Substitute/Replace"
That worked perfectly. You are an absolute god/goddess... I shall be grateful
forever! THANK YOU!!! :-) -- Let me know if this helps! Bay Area DebG "Toppers" wrote: If I understand correctly, the ID in Sheet1 is embedded in the ID name in Sheet2 i.e in the brackets and not in a separate column If this is correct try putting this in B2 in Sheet1 and copy down: =VLOOKUP("*" & A2&"*",Sheet2!A:A,1,FALSE) It assumes IDs & ID names are in column A on both sheets. HTH "Bay Area DebG" wrote: I have two worksheets: 1st wksht has raw data including one column with users' unix IDs 2nd wksht has users' full names After adding a new column to the right of the unix ID column, I want to search for every occurrence of each user's unix ID (in the 1st wksht) and place the user's full name (from the 2nd wksht) into the new column on the right (for instance: Sheet1 unix id="brubble" Sheet2 unix id="Barney Rubble (brubble)" After adding new column to right of Sheet1 unix id="brubble", function searches Sheet2 and every row that contains "brubble" will have "Barney Rubble (brubble)" placed in cell immediately to the right. Hope this makes sense. BTW, using Excel 2003 on a Windows 2000 platform -- Thanks! Bay Area DebG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| perform 1 function, stop, perform different function | Excel Discussion (Misc queries) | |||
| perform a calculation when a certain phrase appears in a cell | Excel Worksheet Functions | |||
| How to perform "ifcount" in many sheets | Excel Discussion (Misc queries) | |||
| How to perform "ifcount" in many sheets | Setting up and Configuration of Excel | |||
| How can perform a summation? | Excel Worksheet Functions | |||
Linear Mode
