Checking if value is in a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

resettable, over-ridable, default cell values 0
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Function in Excel to count and list number of entries of text valuesin a row. 2
Identify part number in list and tag it with characters from another list 4
Using a IF function in a validation list cell 1
Returning value in secocolumn based on selected value in first col 1
Multiple List Analysis 0
Dependant formula 3

Back
Top