Perhaps this might work ..
Sample construct at:
http://cjoint.com/?lnsz6XiIWy
Check_n_Replace_Val_Ed_misc_14112005.xls
Assume Sheet1 and Sheet2's structure are identical,
in cols A to D, data from row2 down, e.g.:
OU Fname Dname Aname
1 FN1 DN1 AN1
2 FN2 DN2 AN2
3 FN3 DN3 AN3
etc
whe
FName =Full Name
DName =Display Name
AName =Account Name
----
Make a copy of Sheet1
In this copy, named: Sheet1 (2)
---------------
Put in B2, copy across to C2, fill down:
=IF(ISNA(MATCH($D2,Sheet2!$D:$D,0)),
IF(ISNA(MATCH($D2,Sheet1!$D:$D,0)),"",
INDEX(Sheet1!B:B,MATCH($D2,Sheet1!$D:$D,0))),
INDEX(Sheet2!B:B,MATCH($D2,Sheet2!$D:$D,0)))
Sheet1 (2) will return what you're after ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ed" wrote in message
...
Can anyone tell me how to accomplish the following:
I have two worksheets with 4 columns (OU, Full Name, Display Name,
AccountName, ). The values in the "AccountName" columns are the same in
both
worksheet, but the values in the other three are different. I need to find
a
way to search the two worksheets and when the AccountName in both
worksheets
match, I would like to replace the "Full Name" and "Display Name" values
in
Worksheet 1 with the values (Full Name and Display Name) from Worksheet 2.