V Look Up Function

Dear All,

Please find the attached file,

I Have Two Tables in the sheet,what i'm trying to sort out is need to get the gross salary of an employee
based on his Name,Badge No,OT Rate,T Rate & Basic.

If Badge No & Name which is A2 & C2 then it should check on the table below A19:E27 then
it should take on the rates which is OT,T & Basic,Multiply OT Hours with OT Rate then Multiply T Rate
with T Hours and finally it should add the basic salary along with that and the end result should be on F2..

Any Help Will Be Appreciated...

Thanks,
Ak