Perform a "Conditional Substitute/Replace"

B

Bay Area DebG

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
 
T

Toppers

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
 
B

Bay Area DebG

That worked perfectly. You are an absolute god/goddess... I shall be grateful
forever! THANK YOU!!! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top