Excel template populating from a worksheet

[Brandy]

Good morning,
I have an excel worksheet containing customer names, addresses, phone
numbers, machine, serial number, type of service, last service date, next
service date, and comments.

I would like to have this information to populate onto another worksheet
template when a user enters a customer name from the other worksheet. I need
the information for one customer to be displayed on this template as to
simplfy the users search and as well as for "presentation".

Any ideas as to a template or functions would be greatfully appreciated.

Thank you

 

[Pete_UK]

You would normally use VLOOKUP to do this - detailed explanation
available in XL Help, or you could have a look at Debra Dalgleish's
notes here:

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

Hope this helps.

Pete