Here is how you can connect data into Airtable, 3 ways:
- using Links, similar with what Data Validation in Excel looks like
- using Lookups, like VLOOKUP in Excel works
- using Roundups, work pretty much like SUMIF, COUNTIFS in Excel