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?
>Solution :
You may try:
=index(xlookup(A2:A,D:D,E:E,))
- Adjust the formula ranges as per your sheet
