Trying to get excel to auto fill a series of fields

[debi7405]

I have a database of customer names, addresses, citys and a field for customer notes. They are linked by individual customer numbers I have to find 40-50 customers per day and put them into a worksheet manually. I was wondering if there was a way for excel to fill in the customer fields based on their customer number. So if I enter a number in the cust ID field, that it will find that customer in the database and fill in the rest of the information for me. I have done this in file maker, rather quickly, but for some reason I am excel-dense.

Thanks in advance

Debi

 

[brettvba]

you could use vlookup formulas or design some code if u can vba