Filling multiple cells from a drop down list

Hi

I am trying to use a drop down menu in two instances where using a drop down menu will have values fill multiple cells.

First: Drop down list where company name is chosen, fills that cell with company name but also fills another cell with pay rate of that company.

Second: Job location is chosen, fills that cell with location and fills other cells with mileage from office and parking rates.

An example would be in column A the hiring company is chosen and it fills column A and column C. In column E the location is chosen and it fills column E, column F, and column J.


Any help would be appreciated as I am trying to make it easy to use, right now I am using drop down menus for companies and locations and having to go in and fill in the rest of the information, simplifying it would allow me to let the employees do it themselves, thanks.