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
Lookup 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.
