Compare columns from different workbooks

[ken957]

I am using a workbook with thousands of lines. Some data is very old and
either missing or or out dated. In particular I am looking to find the
ship_date for each project_id. There is another worksheet that has about 80%
overlap with my workbook. How can i get the good ship_date information from
the other workbook into my workbook, and how can I see which project_ids are
missing in my workbook so I can add those rows?

ken

 

[Thomas [PBD]]

Ken,

This sounds like you want to use the VLOOKUP function.
Workbook A contains thousands of lines with outdated information, and you
wish to pull the correct information from Workbook B. I will assume that
Workbook A and B contain the Project_ID in Column A, and Ship_Date in Column
B.

Vlookup('Workbook A'!A1,'Workbook B'!$A$1:$A$1000,2,False)

This would return the Ship_Date for each Project_ID found in Workbook B. If
the Project_ID is not found within the specified ranges, it will return an
#N/A value.

Hope this helps.