Trying to build 2 spreadsheets that need to communicate with each other at this level:
One of them (first) will have the raw material code, name, supplier, last date of testing, risk rating, test required, etc.
The other (second) spreadsheet will be a record of materials booked in.
Will it be possible that, by typing the raw material code and supplier on the second spreadsheet, it will tell me (by searching on the first) if a testing is necessary? By this i mean:
- Low risk (must be tested once per year for each supplier)
- High risk (every delivery must be tested)
Thanks in advance.