Checking if value is in a list
 

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

Take a look at several techniques he


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



In article ,
"roeaster" wrote:

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