Skip to main content

I currently have a table that has alllll of our data. We want to separate it so it's a bit easier to manage. So, here's what I'm trying to do:

Tab 1 - Master Info. This will have a SKU#, a product name, and a materials cost.

Tab 2 - Wholesale Vendor #1 - We will type in a SKU, and it will bring in the product name and materials cost from Tab 1. 

Tab 3 - Wholesale Vendor #2 - We will type in a SKU, and again, it will bring in the info from Tab 1.

I don't want the tabs to be busy and have extra columns. I'd like it to be a basic "vlookup" type. However, I can't figure out how to do it without a) having the extra columns and b), going into each and every line to pull out the info.

Any tips? Thank you!

 

Once you've gotten the tables linked up you can add lookup fields and this should do what you need I think

Airtable doesn’t have nearly as much power as Excel, but you can partially do what you want with linked record fields & lookups.

I discuss linked record fields & lookups in depth in my free Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning:

https://www.linkedin.com/learning/learning-airtable/ 

Reply


Terms & Conditions