Index match formula for multiple criteria

[nellyc]

Hello All

In the attached I have a pricing list on sheet 2 based on various criteria and on sheet 1 dropdown lists to match the criteria.

In cell B12 i have an index match that I can not get to return a value.

Is Index Match the correct method of returning a result? Or have I just got the formula wrong?

Thank

Nelly

[Ace_XL]

One way..

=SUMIFS(INDEX(Sheet1!D:F,,MATCH(B4,Sheet1!D2:F2,0)),Sheet1!C:C,B6,Sheet1!A:A,B8,Sheet1!B:B,B10)