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.