2 sheet replaceing; row on 1st sheet with row from 2nd sheet

[banderson]

I have 2 sheet in the same workbook:
(APCURRENT,CORPCONTACT)
Both sheets have a column "vendor name".

I want to look at APCURRENT "vendor name" and if the corresponding
CORPCONTACT "vendor name" is the same take the informating in that row
of CORPCONTACT(address1, address 2, city, st, zip code) and replace
then
APCURRENT(address1, address2, city, st, zip code) with it.
But only do this if the to "vendor name" cells are the same.
So for instance.
APCURRENT
column A column B column C column D
Col F Column G
Vendor Name address 1 address2 city
st zip code

A Y MCDONALD PO BOX 123 1st Ave. N New York NY
11111

CORPCONTACT
column A column B column C column D
Col F Column G
Vendor Name address 1 address 2 city
st zip code

A Y MCDONALD PO BOX 546 2nd Ave. N Fargo ND
58133

Vendor names are the same, so replace the APCURRENT INFORMATION with
the CORPCONTACT information.

Any help would be greatly appreciated.
Thanks