Combining multiple non-numeric drop down menu values to produce a numeric pay rate value

I am trying to create an IF/Then formula using the results of multiple drop-down menus with non-numeric values to produce a currency value.  I and my co-workers receive work through a union hiring hall to which we get sent to multiple different venues working for multiple different companies performing a variety of different pay rated tasks throughout the year.  Not all companies pay the same rates for similar tasks, and different tasks within individual companies have different pay rates.  Basically, I have listed out every calendar day of the year as my rows for the sheet with timekeeping columns of information.  I have a drop-down menu for a user to select which company they worked for and another drop menu for the user to select which crew they were performing tasks.  I want the formula to populate the pay rate column with the correct value once the user has selected the company-crew combination from the drop-down menus.  

I obviously already have the Data Validation drop-down menu lists for the Company and Crew choices and also have made a list of varying pay rates.  I am looking for the most efficient way to refer to the value combinations to produce the final value, please.

I already have the total money made for the day calculated using the pay rate multiplied by the various types of hours categories like straight time, overtime, double-time, etc.  I eventually want to make it so that when I enter time period values it will automatically populate the straight, over, & double-time values automatically, so any help on that regard would be appreciated as well to make that formula more efficient.