Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up and data extraction
I am trying to verify that specific numbers are assigned to other specific
locations (numbers or alpha characters). The numbers in question can be assigned up to 5 other numbers or alpha locations. Please see example: material assignment 001575-0393 0100 001575-0393 SIM 001681-0828 0100 001681-0828 0400 001681-0828 0401 001682-0828 0100 001682-0828 0400 001682-0828 0401 I want to check that 001575-0393 is assigned to 0100, SIM, and 0101. I would like to know when they are assigned to the required numbers, assigned to any other number not specified, or if the assigned number is not listed. In the example above, 001575-0393 is assigned to 0100 and SIM when it should be assigned to 0100, 0100, and 0400. I would like to display the assigned number and the locations that are incorrect. Any help would be greatly appreciated. Thank you, Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Extraction | Excel Discussion (Misc queries) | |||
Data Extraction Problem | Excel Worksheet Functions | |||
data extraction | Excel Discussion (Misc queries) | |||
data extraction | New Users to Excel | |||
Data Extraction | Setting up and Configuration of Excel |