Spreadsheet: 171576d1343773697-match-and-determine-frequency-match-and-frequency
Sheet: Sheet1

 |  |  |  | -- In this small sample data table, tue function in     K cells appears to be working as should -- In the larger or master file, the function in K cells     is not finding all the numeric ID matches -- Need function to assure that all alpha-numeric &    numeric IDs are being matched |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.mrexcel.com/forum/showthread.php?343546-Comparing-4-columns-in-excel
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample Table
 | Sample Table
 | Table / File 1 | Descriptions |  | Table / File 2 |  | Table / File 3 |  | Table / File 4 |  | Match Results File 1 & 2 |  |  |  | Table / File 1 | Descriptions |  | Table / File 2 |  | Table / File 3 |  | Table / File 4 |  |  |  | If possible - Match All 4 Columns
 | MNDJ17 | Description 1 |  | 769503 |  | 704706 |  | 769503 |  |  |  |  |  | MNDJ17 | Description 1 |  | 769503 |  | 704706 |  | 769503
 | [NAME] | Description 2 |  | 769301 |  | 704747 |  | 769403 |  |  |  |  |  | [NAME] | Description 2 |  | 769301 |  | 704747 |  | 769403
 | MNDJ17 | Description 3 |  | 711100 |  | 711100 |  | 769303 |  |  |  |  |  | MNDJ17 | Description 3 |  | 711100 |  | 711100 |  | 769303
 | 769311 |  |  | 704747 |  | 769301 |  | MNDJ17 |  |  |  |  |  | 769311 |  |  | 704747 |  | 769301 |  | MNDJ17
 | 769303 |  |  | 704706 |  | 769303 |  | [NAME] |  |  |  |  |  | 769303 |  |  | 704706 |  | 769303 |  | [NAME] |  |  |  |  |  | If all possible - Match all 4 tables / columns & provide ID results
 | 769403 |  |  | [NAME] |  | 769403 |  | MNDJ17 |  |  |  |  |  | 769403 |  |  |  |  | 769403 |  | MNDJ17
 | 769503 |  |  |  |  | 769503 |  | 704706 |  |  |  |  |  | 769503 |  |  |  |  | 769503 |  | 704706
 | SM_List |  |  | DC_TPT_List |  |  |  |  |  |  |  |  |  | SM_List |  |  | DC_TPT_List
 |  | Named Ranges In These Columns |  |  |  |  |  |  |  |  |  |  |  |  | Named Ranges In These Columns
 | Scenario or Situation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Looking for function that if 2 of the columns match, it will generate the ID number
 | I have 4 Excel files with a large list of IDs in them   -- Table 1 is organized by sales   -- Table 2 is organized by known products   -- Table 3 is QAs list of known product IDs   -- Table 4 is table that a department is working  I need to compare these files, match up product IDs & verify which list is more valid or confirm the product IDs that are in actual used |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | It would also be nice if it could add the description, but those may not match or be some variation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If possible - Match all 4 tables & provide ID results, along with associated description
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.mrexcel.com/forum/showthread.php?526010-Look-up-matching-values-across-four-columns
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =LOOKUP(REPT("Z",255),CHOOSE({1,2},"",LOOKUP(2,1/(COUNTIF(,A2:D2)>1),A2:D2)))
 | After verifying Product IDs usage, looking to do the following: -- Develop some type of "Match" verification between 2 or all the    columns or files, which will be compiled into 1 worksheet -- Determine frequency of how many times an ID matches between    all of the tables or files -- Perhaps, prioritize product IDs by the frequency that the IDs     shows up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/708710-how-to-match-values-in-one-column-to-values-in-another-with-a-3rd-column-included.html