CollegestudentHelp me create an automated data entry program in Ex

[Desperate College Student]

I have detailed customer information and I want to be able to type in the
customer ID and have the rest of the information fill itself in. Please
help. All in Excell.

 

[Debra Dalgleish]

As suggested you can use the VLOOKUP function. There are instructions
and examples here:

http://www.contextures.com/xlFunctions02.html

And a sample file here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Invoice for Selected Number'