Check if movie title is in Excel

[Specular]

So, I'm making an Excel workbook to make a movie collection for 4 persons. Each person has his own, identically-built worksheet with a list of watched movies. I'd like to make a column next to the 'TITEL' column, which shows a 'True' or 'False' when a title is entered, so you can check if you or another person has already watched that movie. So basically, it simply needs to check if that word is already in the column or in the 'TITEL' column of one of the other worksheets.

The excel worksheet looks like this:
https://puu.sh/sPKNn/92bce0e7b2.png

Thanks in advance!

 

[Declamatory]

Person has a worksheet. Try this replacing Person 2 etc with the actual sheet name for the 2nd person.

=IF(OR(SUMPRODUCT(--('Person 2'!E:E=E2)),SUMPRODUCT(--('Person 3'!E:E=E2)),SUMPRODUCT(--('Person 4'!E:E=E2))),"TRUE","FALSE")