Index with double match

Good morning,

im struggling with, i think what has to be some kind of index with a double match formula.
I have attached an example.

I have two worksheets.
Worksheet A is my overview. I will need to put a formula there to get the "Hours" for 1,2, and 3 out of worksheet B, based on the weeknumber in the the orange cell which can be changed to the right week number.
Worksheet B is my database of hours for each week for 1, 2 and 3. In this case worksheet A has weeknumber 2 selected so the 10 should be shown in worksheet A.

So somehow i need to match the client, the 1,2 or 3 and the weeknumber.
Any ideas?

Given nature of result (data type) I would be inclined to use SUMIFS approach; using your sample:

Formula:

Please Login or Register  to view this content.

the alternative INDEX/MATCH approach you suggested would be:

Formula:

Please Login or Register  to view this content.

obviously you will need to adapt the above suggestions to reflect fact your source data is, in reality, on a different sheet (unlike your sample).

Thank you both.
I tried the first one. the sumifs one. It seems to work so thats great!!

@samba_ravi,

as the INDEX/MATCH approach in post #2 illustrates {itself devoid of dependency on row 5}, you don't need to use Volatile OFFSET -- I'm not sure why you would be advocating this unnecessary, and persistent, calculation overhead?

an outer IFERROR can be appended as required.