I have a google sheet that is collecting the entries from a google form. I have two columns full of email addresses. I need to compare them and if the email from list A is found in list B as well, then I want to write "paid" in a third column, next to the email of list/column B. If the email in list A isn't found in list B then "unpaid" should appear instead.
I'm an absolute beginner and would be very thankful for simple answers.
you can use formulas to do this. The formula given below tries to find the match of A2 cell in the B2:B Range with match() formula and if the match is obtained then it add the "paid" string else adds "unpaid"
=IF(ISERROR(MATCH(A2,B$2:B,0)),"unpaid","paid")