Need Formula for Bill for Business

Each month I get a list of codes that correspond with places my employees work and what their hourly rate is for that employee. For example the code BT03REGU is a standard employee working regular time which is $68.70 an hour. Through out the month that code gets used many times at different dates. What I want it to do is look at the column of the BT codes and which ever of the 6 codes there are it puts the corresponding amount of money for hourly pay in another column. I would assume a need some sort of database that the formula can reference to see what codes equal what hourly rates. It could be a Macro but i though I'd start here first. I will provide an example showing the 6 codes and what they equal and a snippet of the monthly bill and how its laid out. I tried to explain it as best as I could but I will answer back quickly if you have a question. I have Microsoft office 2013
Thanks,
Colt M

Excel forum.xlsx

Ill give it a try and report back. Thank you so much

Okay so the first part worked great thank you so much. Now comes the next part. In another excel sheet I get it has employee name, date, where they worked, when, and what type of hours it was. Last time you helped me determine money for the BT codes, well now I need a way to take a list of names and determine if the name gets a BT04 code or a BT03 code(04 is foreman and 03 is standard employee) What is has to do is look at what employee it is then look at what type of hours it is and the out put would be a BT04 or BT03 code. It has in the column the last part of the code so I need it to add on the BT04 or BT03 depending on employee. Sorry for the long posts btw.

Thanks a million
Colt M.



Excel forum 2.xlsx