Fill cells automaticaly from other entry

[wooptidooo]

I created a drop down list (data, validation) of employee names.
I would like the other cells to be filled out automaticaly for their adress,
city, phone
when I select one of the name from the list.

 

[Frank Kabel]

Hi
have a look at the VLOOKUP function for this. <See:
http://www.contextures.com/xlFunctions02.html