Hi
I’m really confused about lookup fields and assumed they worked in a similar way to vlookup in excel and google sheets.
I have two tables:-
Orders
Products
The Orders sku field needs updating with the sku field from the Products table.
Is this possible and can someone show me an example please.
Thanks
Jonathan
+27Lookup fields in Airtable do not work like vlookup in Excel. A vlookup in Excel search a range for a matching value, but an Airtable lookup field pulls in information from a linked record. Despite the similar sounding names, they do very different things.
I recommend you structure your base to have a junction table with linked records joining orders with products. The support article on many-to-many relationships has more information.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
