Data Match

CatherineGPR Posts 4 Registration date Thursday February 19, 2015 Status Member Last seen March 5, 2015 - Feb 19, 2015 at 10:16 PM
I have 2 workbooks, one with raw data the other used for reporting. The workbook with the raw data has 2 columns one being publication number and the other column contains a figure that measures how many people see the publication. The other workbook we report any feature we get in the publication and manually enter the figure that corresponds with that publication that appears in the other workbook. Is there a way I can have this figure automatically filled in by using a formula?