sum Vlookup

[Mega1]

I want to use lookup to add all in a column table 1 has Company, Tax ,2106,2017,2018
table 2 has productid, Product Name, Company,Rate,Gross.
I want to be able to add up the gross for each company

any help you can give

 

[Joe4]

It sounds to me like you want a SUMIF formula instead.
See: https://www.techonthenet.com/excel/formulas/sumif.php