Linking a cell that has Data validation to another sheet with a index and match formula

[janetdelapaz]

I have a schedule that has different employee, paid code and total hours. I am trying to calculate the total pay per employee per month based on the paycode. Each employee have 5 different paycodes. On Sheet 2 I have column of each employee on B1 to O1 and in row A2 to A6 I have the paid code. I've used the Index and Match formula to pull the rate for the each employee. One Sheet 1, Column B , I have Data Validation listing each employee and for each employee on Column D I have data validation listing all the pay codes. I want to be able to link the pay code in Worksheet 1 to the Pay code in worksheet 2 so that when I select an employee and their paycode in the first sheet it would go to sheet 2 and return the rate of pay in the Worksheet. I don't know how to do this. Do I use lookup, or a formula? All I want to do is get the right paycode for each employee but all of the rates are on the second sheet. Am I using the wrong formula. Help, I am new to this.

Thanks