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" wrote:

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