Sondra,

Make sure you reference to the table on the "CUSTOMER" sheet is Absolute,
not relative like it is now.

Change your formula from...

=VLOOKUP(D12,CUSTOMER!A2:F6,2,TRUE)

....to...

=VLOOKUP(D12,CUSTOMER!$A$2:$F$6,2,TRUE)

Check out this web page for more info on Absolute and Reletive references:
http://www.cpearson.com/excel/relative.aspx

Is this formula the one used in the Customer Field? If so, us and IF()
function to make it appear blank until a customer is selected.

The IF() function looks something like this:

=IF(logical test that results in TRUE or FALSE, value if true, value if
false)

so your formula would look something like this:

=IF(D12="","",VLOOKUP(D12,CUSTOMER!$A$2:$F$6,2,TRU E))

HTH,

Conan Kelly




"Sondra" wrote in message
...
Multiple Part question:

Created an Invoice with various cells. There is a Customer Name, Address,
City, State, Zip and Phone Number. I've created a separate worksheet
that
contains the Customer information. I created a Drop Down Box on the
Invoice.
Created a VLOOKUP for the Address, City, State, Zip and phone number
Cells.

=VLOOKUP(D12,CUSTOMER!A2:F6,2,TRUE)

Question 1:

The 1st few records work perfectly.
1. I choose the Customer from the drop down list and the remaining fields
self-complete.
2. There are several records that won't populate. They show on the drop
down but none of the fields populate when you choose the customer.
3. I have verified there is data in the VLOOKUP fields

Any suggestions would be great.

Question 2:
How do I make the Customer Field be empty until I choose the drop down
arrow.

Thanks in advance.