Matching multiple criteria

In my spreadsheet, on Sheet "Aug19", I would like to pull a value from a table based on two criteria.

Criteria 1 - Name of Employee
Criteria 2 - Work Centre (WC) they will be working in.

Each employee has a particular efficiency in each work centre, and I would like to return the hours value that they contribute in that WC.

I built a simple index match to find the hours, but I do not know how to also find the proper column to pull the hours from at the end of the formula.

Right now I have:

=INDEX(Skill!A1:O6,MATCH(A12,Skill!A:A,0),5)

I have a feeling this is simple, not sure where I am going wrong here.

I just realized on the skills tab, the columns should be named the opposite. Might help simplify the formula too.

For example WC01 Eff should have the efficiency value, not the hour output. I will update a new sheet when I get a second.

So I had originally marked this solved, as the solution provided by @avk did work correctly. However, I've gone and updated the workbook with the real data, which includes a much longer list of employees on the "Skill" tab, and it looks to have broken this formula. I tried to expand the formula to encompass the new employees, but I kept returning an error.

Any assistance in understanding how the formula works and how to expand it would be greatly appreciated. I can see it has two sections that are looking at a range and seeing if they match with the Employee name given, but I don't understand how the * works in this formula or what the last section is doing. It seems to be looking up the third peice of info based on the other two, but doing so using arrays and binary?

=SUMPRODUCT((Skill!$A$2:$A$6=$A12)*(Skill!$D$1:$O$1=$B12)*(Skill!$D$2:$O$6))

Thanks AliGW - that got it running again. Any chance you or another could explain how it's working? I seem to be missing something as I don't work often with array formulas.