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