Vlookup with sums
 

I have the following spreadsheet.
1609719837 M51410 10 Ser - 5/8" x 50 Ft. 2000
1609710593 2058100 5/8 X 100 Platinum 100
1609718669 10TNSGF 10 Ser - 1/2" x 50 Ft
1609719839 M51470 25 Ser - Industrial 3/4" x 75 Ft. 500

Column A is Product Number, Column B is a Description and Column C is the
number of pieces we will be producing.
I have a table that does a vlookup on the Product Number and returns a unit
of measure which I multiple by the number of pieces we will be producing. My
question is how can I have one formula at the bottom of column C that will do
all the vlookups and then sum them together.

Vlookup with sums
 

Take a look SUMIF function in help menu


"klawk" wrote:

I have the following spreadsheet.
1609719837 M51410 10 Ser - 5/8" x 50 Ft. 2000
1609710593 2058100 5/8 X 100 Platinum 100
1609718669 10TNSGF 10 Ser - 1/2" x 50 Ft
1609719839 M51470 25 Ser - Industrial 3/4" x 75 Ft. 500

Column A is Product Number, Column B is a Description and Column C is the
number of pieces we will be producing.
I have a table that does a vlookup on the Product Number and returns a unit
of measure which I multiple by the number of pieces we will be producing. My
question is how can I have one formula at the bottom of column C that will do
all the vlookups and then sum them together.