Automatically selecting staff hourly rate and grade

Hello All

Apologies if this question has been posed or answered before but I have been trying to resolve this using vlookup and IF statements but I am getting nowhere.

I have attached a copy of the excel sheet.

This forms part of a larger costing sheet. in the select staff column there is a drop down list so we can select which members of staff will be working on a project. What I want to happen is that once the person(s) have been selected the staff grade and hourly rate columns are automatically populated.

Thank you.

revisedStaff costs - 15-09-2015.xlsx
One way is, put the values in column M into column O as well. Then you can do this.

Assuming that your staff list is set up as rows with columns to reflect staff grade and hourly rate then "Index / Match / Match" will do what you are looking for.

See if this will help.
simon3-Staff costs - 15-09-2015.xlsx