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