Find and Replace Excel Help

[jazzys2]

1	A	B		D	E
2	jdoe	Acct		jdoe	Accounting
3	jsmith	Business		jsmith	Business Office
4	tmax	HR		tmax	Human Resources
5	hgerald	Acct		hgerald	Accounting
6	dhummer	Admin		dhummer	Administration
7	dlane	Sec		dlane	Security
8	rsmith	Admin		rsmith	Administration

<tbody>
</tbody>

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.