EXCEL in the table on how to screen, generating another table

Is a function in another form generation.
Table 1 below
A feed 1 3
B material 1 8
C materials 3 11
A feed material 3 4
B 2 9
C material 1 6
A materials 3 9
A material 2 8
C materials 3 10

in Table 2 on how the employment-generation type in the following table:

A feed 1?
A material 2?
A feed 3?
B material 1?
B material 2?
B expected 3?
C material 1?
C material 2?
C expected 3?

Note 2 of 3 must be generated automatically, the top? should seek out and.

in Table 2 B2 enter the formula:

= VLOOKUP (A2, Table 1! A:B, 2,0)

Copy down the formula = sumif (sheet1! A:a, a1, sheet1! B:b) it is simple to use as long as the PivotTable on the line.There can be summarized with the classification resolved, but keep in mind that the use of classified summary When the first order.