Address from one worksheet to another

[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

 

[Guest]

Hi Duncan
Assume sheet 1 is the list of name/addresses.
Create a Dynamic name list on the sheet1 with names see :

http://www.contextures.com/xlNames01.html#Dynamic

Then on sheet2 use data validation using list in your Name Column to get the
drop down list. Then use vlookup to get the Address1 and Address2 in the
other coloumns.

HTH

 

[Duncan Sibbald]

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

 

[Guest]

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