A formula that evaluates a table to return only the criteria you identify in specific cells.
In this example we are looking in column A to get the generation value, column B to get the product value and then telling the formula where to find the prices which are in column C. We create an input table that holds the values we would like the formula to look for. We are looking in E2 and F2 for these values in our example.
=SUMPRODUCT((A2:A7=E2)*(B2:B7=F2)*C2:C7)
DiG with Data 