address look up from another sheet

[irrefutable14]

I have a sheet with a bunch of data that I'd like to pull the vendor addresses from and have them automatically imported into into a separate sheet. I'd like to use the vendor ID and or Vendor Name in order to pull the addresses over to the other sheet as a cross reference. Could anyone get me started in the right direction please. Thanks


"Address" -- sheet 1

A -vendor id
b - vendor name
c- address 1
d- address 2
e- city
f- state
g- zip code


"Vendors to Confirm" -- sheet 2. Where I'd like the address to be pulled over to

A -vendor id
b - vendor name
c - current balance
d- address 1
e- address 2
f- city
g- state
h- zip code

 

[Special-K99]

in Sheet2!B1
=VLOOKUP(A1,Sheet1!A$1:G$1000,2)

in Sheet2!D1
=VLOOKUP(A1,Sheet1!A$1:G$1000,3)

in Sheet2!E1
=VLOOKUP(A1,Sheet1!A$1:G$1000,4)

in Sheet2!F1
=VLOOKUP(A1,Sheet1!A$1:G$1000,5)

in Sheet2!G1
=VLOOKUP(A1,Sheet1!A$1:G$1000,6)

in Sheet2!H1
=VLOOKUP(A1,Sheet1!A$1:G$1000,7)