I haven't been able to figure this out or find the right article for
help so I thought I would post. I have an invoice I'm creating. I
would like to have a drop down list in it to select a company name and
when selecting it, the contact name, address, state and zip will
autofill in the invoice.

So I have an invoice with B11 where the company name goes, from there
B12 - B14 contains the contact name, address, state and zip. Now I
have another sheet named "customers" with the information is seperate
cells like below:

A1 B1 C1 D1 E1 F1
CompanyName Contact Address City State ZIP

So how can I get it so that I select a "companyname" from a drop down
list and it autofills the fields below it with data from another
sheet? I've been trying with vlookup but cannot get it to work (I
just think that I don't understand how it works).

Bonus: I'm using Excel 2007 and am Excel illiterate.

Thanks for the assistance.