How to connect data from 2 different tables so that if the same email appears - I will get a V in th

Hey friends
I have 2 tables in one base.
In one table I have a list of all my leads and in another table I have a list of those who paid money for the workshop I give.
I want to make it so that in one table there will be a column that checks if the email of that lead exists in the other table of the payers and if so, to add a V in the checkbox.
Is it possible?
And if so, how do you do it?
Many thanks to the best community in the world!