Find and Replace Excel Help

[jazzys2]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]jdoe[/TD]
[TD]Acct[/TD]
[TD][/TD]
[TD]jdoe[/TD]
[TD]Accounting[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]jsmith[/TD]
[TD]Business[/TD]
[TD][/TD]
[TD]jsmith[/TD]
[TD]Business Office[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]tmax[/TD]
[TD]HR[/TD]
[TD][/TD]
[TD]tmax[/TD]
[TD]Human Resources[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]hgerald[/TD]
[TD]Acct[/TD]
[TD][/TD]
[TD]hgerald[/TD]
[TD]Accounting[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]dhummer[/TD]
[TD]Admin[/TD]
[TD][/TD]
[TD]dhummer[/TD]
[TD]Administration[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]dlane[/TD]
[TD]Sec[/TD]
[TD][/TD]
[TD]dlane[/TD]
[TD]Security[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]rsmith[/TD]
[TD]Admin[/TD]
[TD][/TD]
[TD]rsmith[/TD]
[TD]Administration
[/TD]
[/TR]
</tbody>[/TABLE]














I need to take Column A and compare with Column D, and if they Match, then I need it to Replace Column B with Column E.

So if jdoe (A2) matched a Column D Value, then replace Acct with Accounting.

Any Thoughts? Hopefully I've explained it well enough.

Jazz

 

[jazzys2]

I'm thinking something with vLookup but i can't figure it out.

 

[HalfAce]

Maybe I'm not seeing the big picture, but if your data is laid out like your example is (comparing columns A & D of the same row), perhaps you could get away with a simple formula in column B?

Something like:
=IF(A2=D2,E2,"")

Hope it helps.

 

[jazzys2]

So imagine column D has many different names in it. I need it to search column D for the right match.

 

[jazzys2]

 

[HalfAce]

Using your example as range A1:E11, you could use VLOOKUP like so.
In B2, enter the formula:

=VLOOKUP(A2,D$2:E$11,2,0)

and copy it down column B.

Hope it helps.