If the email in sheet-1 exists in sheet-2, copy the value in sheet-2 Type into Sheet-1 Status column.
I've filled in the desired Status values.
Sheet-1
Status (formula) | |
---|---|
abc | |
xyz | unsubscribe |
123 | bounce |
Sheet-2
Type | |
---|---|
xyz | unsubscribe |
123 | bounce |
qrs | bounce |
This formula checks if the email value exists and writes "found" for Status if it does. (This is for row 43)
=if(COUNTIF(Sheet-2!A:A, A43)>0,"found","")
I'm thinking I need to use lookup? But how?