| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
| LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
| Refresh a Validation List? | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Linear Mode
