I am not even sure if this is possible or not, but here it goes.
I have two spreadsheets.
Each spreadsheet lists a bunch of parts and part numbers.
Spreadsheet A is the database of existing parts in the system.
Spreadsheet B is a list of parts from a batch.
In Spreadsheet B I want to be able...