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

 

[R..VENKATARAMAN]

will not VLOOKUP be useful here?
vlookup will be useful if the vendor name is in the first column in sheet
2(corp contact sheet)or atleast in the relevant range.
use this function in sheet1(apcurrent) referring to sheet2.
something like this
=vlookup(a2,sheet2!(the range),(column no.taking vendor name as column
1),false)
otherwise index-match combination can be used.
see help.