IF AND Statement - Employee Name, Position, and Wage

My IF AND Statement is working, but I think that once I add another employee it won't any longer. My statement takes the employees name and their position and then resolves a wage. It currently looks like this : =IF(AND(C10="James",D10="Journeyman"),Sheet2!$D$4,IF(AND(C10="James",D10="Apprentice"),Sheet2!$D$3,IF(AND(C10="Mickey",D10="Journeyman"),Sheet2!$D$6,IF(AND(C10="Mickey",D10="Apprentice"),Sheet2!$D$5,0))))

I'm trying to get the value of the hourly wage of a position for either a Journeyman or an Apprentice in a cell. One problem is that that position wage isn't the same for each employee. I have the names of the employees(column C), the positions (Column D) , and the wages on Sheet2!C. I'm currently only using the wage column (D) from sheet2, since I'm using specific text in my formula. I feel like there should be a much easier way for me to do this but I couldn't think of a way to express it in words that excel or google would understand. I tried to create a list of employee names and positions but I couldnt figure it out how that would help.

If I have ten employees I can't have the statement read IF(John and Journeyman=10),(John, Appren.=5), (Kevin and Journeyman=13),(Kevin and Appren=8) because it will end up being 20 different statments and if I ever added another position then it could get really messy fast.

Sorry if I'm a bit confusing. I'm trying to provide as much information as possible.

Hi -

It's hard to tell without having a spreadsheet to look at. Would it be possible to use VLOOKUP to match names and correlate the classification to the number of columns to count over to the correct wage rate?

Me again -

Check out the attached spreadsheet for an example of what I described in my last post.

Hope this helps.

This makes a lot more sense! Thank you very much for your help.