I have different tabs with name lists.
I need to make an analysis on when a name appears on a tab or not, meaning:
On tab 1, we have a list of names.
For Advertisement 1, I want to know if each person read or not our advertisement. On tab 2 I have a list of the people who read advertisement 1.
I need a formula that states something like:
If B3 (one name on tab 1) appears on tab 2, then return an “X” on C3. If it doesn’t appear, then return nothing.
Can anyone help me?