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