Lookup with conditional

[Juan_David_Vizc]

Hi!

I’m stock with this, hope you can give me a hand.

I have to tables, orders and shipping costs.

On the order tables I know what’s company is sending the order and the delivery city.

On the shipping cost table I have how much shipping cost for every company to every city.

I don’t know how to match it in order to get the shipping cost for a specific company/city on the orders table.

[JonathanBowen]

Hi @Juan_David_Vizcaya_S - I think you can use the method outlined in this post to achieve what you want:

Auto-linking between tables? Ask the community

Hello Airtablers, I need to automate links between a table full of User records, including a unique user ID field, and a table full of Invoice records, each Invoice also includes a user ID field. New Invoice records get created more frequently than User records. For each new Invoice record that gets written to my Invoices table, I want Airtable to recognise the User ID and use this to auto-link to the corresponding User. A single User will have multiple Invoices, and each Invoice uniquely belo…

It is a manual step, but not too onerous.

In your orders table, you can have a formula field “city-company” and on your shipping cost table have the same as your primary field. The copy and paste will then link these two tables and you can lookup the appropriate shipping cost onto the orders table.

JB