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