Lookup/Fill-in form ?

Hello,

I'm having trouble trying to come up with a way to insert data fields into a spreadsheet form. I have a travel authorization form that I would like to have automatically fill in the required fields based on typing in a name. i.e. I would type in an employees name, and it would automatically fill-in the correct address, etc for that employee. I have attached a spreadsheet that contains one sheet as the form, and another sheet containing the employee data.

I know nothing about VBA, but I have a feeling that is where I need to go...

Any help is GREATLY appreciated !!!

Thanks !

Bob K.
Anchorage, AK

You don't need VBA, use VLOOKUP

See if this helps

http://www.excel-it.com/excel_functions.htm

You could also use Data Validation to create a list of names to choose from

Please mark the question solved