Balancing totals from two workbooks

[Closed]
Report
Posts
1
Registration date
Wednesday February 20, 2013
Status
Member
Last seen
February 20, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have tried some pivots, some access but still no solution. I have data coming from two different sources. One has a breakdown for some companies and the other just has the totals for companies. They have unique company id numbers that I can use for comparisons. H E L P !

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I think you need to provide more detail. In any case, you would be looking at either VLOOKUP or/and MATCH function of excel