Enter a customer name in the invoice workbook when the names are .

We use Excel to make invoices for our customers. I have a customer list of
800 in one workbook. The invoices are in another workbook. At this time, we
manually type in the customer name & address etc. How can I set up either a
combo box or a formula that when I type in the first couple of letters of a
customer name that Excel will enter the remaining info automatically. I do
not want the customer list in the same workbook. Thanks for your help

You could use a vlookup on the customer name after it is typed to automatically find the address... but i don't think there is a way that Excel can guess what name you are using from a few letters. Not like an autocomplete anyway. Again you could use a vlookup on the first letters of a name in one cell.