Pulling my hear off; please enlight me ❇

[dez_azeaze]

I’ve been incredibly focused without achieving what a simple VLOOKUP in Excel allows me to do.
What i am missing

This seems rather simple a priori

this table is created by a form, fairly simple

Then another table from another form. I just want to have a Y/N in the column “exists on enrol table”

I’m ready to use integromat if needed, i just need some guidance for this

The only matching key is email and cannot be exposed in the 2nd form for privacy reasons

[ScottWorld · Accepted solution]

You’re right, you can’t do that natively with Airtable. I would recommend using Zapier or Integromat to help you with this.