Checking if value is in a list

[roeaster]

I have a list of parts, some valid, some not. I have a second list of only
valid part numbers (on another tab). How can I check to see if each item on
the first list is on the second list? A TRUE/FALSE output would be fine.

P.S. I understand that "list" can mean something special in excel but I just
mean a series of part numbers in no particular order.

Thanks in advance,
Roe

 

[JE McGimpsey]

Take a look at several techniques here:


http://cpearson.com/excel/duplicat.htm