I have a workbook with two sheets (sheet 1 and sheet 2). On sheet 1 I have company names in column A. The names only appear once. On sheet 2 column A, I also have company names and the company names can appear more then once.
I need a formula in sheet 1 column b that looks at sheet 2 and matches the company name in column a. If the name mach, add the amounts from sheet 2 column S to sheet 1 column b.