Maybe this is a stupid question, but I’ve been wracking my brains trying to figure it out and couldn’t find a solution.
Table 1 - list of 300 users with assigned devices by serial number.
Table 2 - list of 1000 devices with other specs, including serial number.
What I am trying to do
Create a third table with all Serial Number listed on Table 1 (I can copy manually) and display on Field 2 the name of the user (record from Table1) and display on Field 3 Other Spec (record from Table2).
On excel, it’s something simple that I can resolve with VLOOKUP (value, table, col_index, [range_lookup]). Any solution/idea for Airtable?
Thanks so much!