Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jul 29, 2020 05:04 PM
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
Jul 29, 2020 05:12 PM
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.