Pull data from one sheet to another if a company name matches

**toddbn** · 03-30-2015, 04:43 PM

This should be easy for an excel guru. I am good at Excel, but this is over my head. I have a excel workbook and I have one primary sheet that is pulling data from a database. In this sheet there is a column (B) that lists company names. the database value it is pulling is [@[company_name]]. There are roughly 200 rows that have unique company names in them, then there are about 10 columns that pull various information.

I have another sheet in the same workbook that has data that is different. This data comes from another system that exports to excel, and I just copy from that export and paste it into this second sheet so the data is in the same workbook. It is not ideal but it is good enough. This sheet also has a row of company names that match exactly the company names on the first sheet. There are 5 columns of data in that sheet that I want copied over to the first sheet based on the match of the company names.

So if companyA is found in sheet 2, then copy those 5 cells of data in that row to the designated 5 cells in sheet 1 that matches companyA.

Hope that makes sense? Any help would be greatly appreciated.

**Jocote46** · 03-30-2015, 04:56 PM

do you know how to use the vlookup function?, it seems that's all you need to do. Can you post a sample sheet to get better idea?

**toddbn** · 03-30-2015, 05:07 PM

Here is a sample workbook. I forgot one other complication at that is that in the second sheet there can be more than one row per company name. If that is the case I need to add up all the amounts in each column for that company name and put the sum in the first sheet in the right column for the company. Hopefully the workbook will make it clear.