Spreadsheet: 742615d1627917086-how-to-get-unique-matching-records-in-the-drop-down-list-excel-query-unique-matching-records-in-dropdown-list
Sheet: Sheet7

Master LIST: LIST1 |  |  |  |  |  |  |  |  | Output data List:LIST2
Product | Make | Model | Spec1 | Spec2 | Spec3 | Spec4 | Spec5 |  | Product | Spec1 | Spec2 | Spec3 | Spec4 | Spec5 | Make | Model
Cont | SC | SC-A | 1P | 220VC | 9A |  |  |  | This is a drop down list containing a list of unique values from Table 1,ColumnB. Dropdown is avaiable in all rows of List2, ColumnK. | This is a drop down list containing a list of unique values from List1, ColumnE which match the "product"selected in Table2, ColumnK. This dropdown will be available in all rows of List2, ColumnL & criteria for contents will be as described above. | This is a drop down list containing a list of unique values from List1, ColumnF which match the "product"selected in Table2, ColumnK. This dropdown will be available in all rows of List2, ColumnM & criteria for contents will be as described above. | This is a drop down list containing a list of unique values from List1, ColumnG which match the "product"selected in Table2, ColumnK. This dropdown will be available in all rows of List2, ColumnN & criteria for contents will be as described above. | This is a drop down list containing a list of unique values from List1, ColumnH which match the "product"selected in Table2, ColumnK. This dropdown will be available in all rows of List2, ColumnO & criteria for contents will be as described above. | This is a drop down list containing a list of unique values from List1, ColumnI which match the "product"selected in Table2, ColumnK. This dropdown will be available in all rows of List2, ColumnP & criteria for contents will be as described above. | This is a drop down list containing a list of unique values from List1, ColumnC which match the entries made in same row in Columns K, L, M, N, O, P.This dropdown will be available in all rows of List2, ColumnQ & criteria for contents will be as described above. | This is a drop down list containing a list of unique values from List1, ColumnC which match the entries made in same row in Columns K, L, M, N, O, P, Q.This dropdown will be available in all rows of List2, ColumnQ & criteria for contents will be as described above.
 | LT | LT-D | 2P | 220VC | 9A
 | SC | SC-B | 3P | 220VC | 12A
 | LT | LT-A | 3P | 24VC | 400A
 | AB | AB-E | 4P | 425VC | 125A
 | AB | AB-E | 4P | 425VC | 95A
ACB | SC | SC-MVS | 3P | MF | LSI | 80A | 2L
 | LT | LT-Apower | 4P | EF | LSIG | 250A | 6L
 | SC | SC-SP | 6P | MD | LS | 340A | 22E
 | LT | LT-Dpower | 1PX | ED | LS | 900A | 2L
 | AB | AB-Emax | 2PX | MD | LSIG | 200A | 6L
 | AB | AB-Emax | 2PX | MD | LS | 2200A | 6L
SST | SE | SE-EM | SFM | LE | POP |  |  |  |  | If no matching records found,drop down list should not open
 | TRI | TRI-Ent | MFM | LC | POP
 | SC | SC-6200 | SFM | LE | RS490
 | TRI | TRI-25AD | MFM | LE | RS490
 | SC | SC-EM6440 | MFM | LC | MDBU
 | SE | SE-EM2Z | SFM | LC | MDBU
PFC | YACAP | YACAP-Box | HD | 44VC | MP | H1
 | SC | SC-Can | EHD | 48VC | MP | H1
 | ELE | ELE-Power | GHD | 52VC | AP | H2
 | ELE | ELE-Power | SD | 44VCX | MDX | H2
 | SC | SC-XD | SD | 44VCX | MDX | H2