IF formulas and Vlookups - Retail costing

[Cfontenot]

Hi! 

I'm new to Airtable, and my company just started using Airtable to build our merchandising assortments. We currently buy products from both US and AU with different duties and transit costs associated with each region. Previously when working in google docs we used IF formalas and vlookups to reference those costs depending on the type of buy. Is there a way to add that data set somewhere in Airtable to reference? I've added a screen shot of the data set of the duty and transit costs and our google doc formula for reference as well! Appreciate any help!

[TheTimeSavingCo]

Hmm, try creating a new table called "Rates" where you put this information.  Then link it to your existing table and add lookup fields to display those values

Link to base