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