Vlookup Automation in Airtable

So I have a sheet in Google Sheets that works exactly as I need it to, but I’d prefer to bring it over into Airtable if I can. I have a master sheet of contacts (~2500) with roughly 20+ fields. I’d like to be able to drop in a new tab of data into Airtable and have the master tab be populated with any new data that matches up with a specific field in my master table (i.e. URL field). So for example, if I add a new sheet that has contact names and emails as a new tab, my master sheet will update with any new contact name/email info based on the URLs matching between the two sheets. In Google Sheets, adding a Vlookup formula will accomplish this, but I’ve not figured it out between automations and formulas so far in Airtable. Any help is much appreciated!

Here is a quick Loom video to describe what I’m looking to accomplish: Loom | Free Screen & Video Recording Software

1 Like