Address from one worksheet to another

  • Thread starter Thread starter Duncan
  • Start date Start date
D

Duncan

Hi,

I have a worksheet which contains customer names and their addresses, so
that customer name is in column A, address line 1 is in column B, address
line 2 is in column C and so on.

I have a separate worksheet which has the customer name in a drop down list
in Cell A1. What I want to happen is when I choose a customer name in cell
a1, it picks out the relevant line from Column B (address line 1) and puts
it in cell A2, and address line 2 in cell A3 and so on. This is for
invoicing.

Is this possible and, if so, what formula would I need ?

Any help gratefully received,

Duncan
 
Al,

Thanks for your reply. With your help I've done the first part (up to
getting the drop down list). I'm stuck on the vlookup bit though.

Thanks,

Duncan
 
Sheet1:
A1 = Name
B1=Address1
C1=Address2

Sheet2
A1=Dropdown List
B1=vlookup(a1,range,2,1)
C1=vlookup(a1,range,3,1)
where range is the table array where your nae/address information is located.

HTH
 
Back
Top