Amazing. Thank you. I knew it was something not too difficult.

"Sheeloo" wrote:

One way is to use VLOOKUP
Assuming Citizens are in Col A of Sheet1 and Enemies in Col A of sheet2
Enter this in B1 of Sheet1 and copy down till end of your data
=VLOOKUP(A1,Sheet2!A:A,2,False)

Now filter Col B on #N/A... You will get the list of Citizens who are NOT in
Enemies list.

"NickySams" wrote:

Say I have 2 lists. One of which we'll call citizens, the other we'll call
enemies. everyone on the citizens list should also be included in the Enemies
list, but they're not. I'm trying to have it list the names that do not show
on the enemies list. How would I go about doing this? Is it an INDEX function
or a MATCH function? Been tearing my hair out on this one. Thanks!