Have Separate workbooks containing data from two different time periods (will refer to as before and after). What formula or lookup could be used to list which values on the "after" workbook are also contained on the "before" workbook? Once these values have been listed, what formula would be used to calculate the difference in values from the before and after quantities?
-List which GL# is on both before and after (Column A)
-From the values listed, what is the sum difference (Column C)
Before
After.JPGBefore.JPG
Bookmarks