IF function applying to multiple tabs

Hi,

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?

thank you

 

By: Laia

Leave a Reply

Your email address will not be published. Required fields are marked *