I am creating a table which lists our shipments of containers.
I need a column of data to pull data from another sheet, if a 3rd column’s contents match the data on the other sheet.
For example. On sheet 1, in Column 1, I enter a serial number. In column 2 of sheet on is a Lot Number.
Now on sheet 2, I have a table as well as a form view. On the Form view, a person on our ops team enters a serial number and creates a new record. Once that record is created, I want column 2 of sheet to automatically: a) check to see if the serial number entered in the form (which created said record) is listed in column 1 of sheet 1; and b) if it is listed there, to populate column 2 of sheet 2 with the relevant data in column 2 of sheet one.
it’s basically a lookup function but is reliant on several different data points.
I have tried the link function within Airtable but it doesn’t seem to be able to handle this. If it can, it’s not at all straightforward.