Hello, i have a problem - can someone tell me how to auto fill 2 other cells if i select one record in one cell from drop down list. I know only how to do it with "if" function but it is very slow and uncomfortable cause i have huge amount of information and it doesnt work when i choose information from another sheet.

For example, i choose in a1 employee from drop down list (all employees, their IDs and job titles are in other sheet) and i need to fill a2 and a3 with the corresponding ID and job title.

Thanks.