Lookup with conditional

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.

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

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

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.