VLookup Sum Result Help.

Could any help me, how I can add vlookup results, in the same column.

C.Code Customer Name Qty
EC300 ABC Company 14540.00
EC800 XYZ Company 2045.50
EC800 XYZ Company 18500.25
EC900 PQR Company 26500.00

Like above case C.Code EC800, products sold twice in this month total qty (2045.00, 18500.00) 20545.00.

Vlookup gives the first value, ie 2045.00, how I get the sum value instead of first value in summery page.

or there is any other function for getting the same result
Looking forward your help.

Thanks
BS

dominicb thanks for your quick help.

I find its a right place to discus and share knowledge.

and great to remain part of excelforum.

Regards
BS