Spreadsheet: 883895d1732651329-creating-a-list-in-data-validation-long-list-in-data-validation-list
Sheet: Sheet3

 |  |  |  | drop downs here of models
 |  |  |  |  |  |  | Product code | Model
 |  | Enter Product Code |  |  |  |  | A0S430A240032235 | KKKE55LS01BGUXXU
 |  | A0S430A240032235 | drop list |  |  |  | A0S430A240032235 | KKKE55LS01BHUXXU
 |  | A0S430A240032228 | drop list |  |  |  | A0S430A240032235 | KKKE55LS01DAUXXU
 |  | A0S430A240032229 | drop list |  |  |  | A0S430A240032235 | KKKE55LS03DAUXXU
 |  |  | drop list |  |  |  | A0S430A240032235 | KKKE55KKK60DAUXXU
 |  | AND SO ON | drop list |  |  |  | A0S430A240032235 | [NAME]
 |  |  | drop list |  |  |  | A0S430A240032235 | [NAME]
 |  |  | drop list |  |  |  | A0S430A240032235 | KKKE55KKKN85DBTXXU
 |  |  | drop list |  |  |  | A0S430A240032235 | KKKE55KKKN90DATXXU
 |  |  | drop list |  |  |  | A0S430A240032235 | KKKE55KKKN95DATXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE55S90DAEXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE55S95DATXXU
 |  |  |  | Only Models where product code |  |  | A0S430A240032235 | [NAME]
 |  |  |  | matches CELL TO THE LEFT (COLUMN c) will appear |  |  | A0S430A240032235 | KKKE65LS01DAUXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE65LS03BGUXXU
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | KKKE65KKK60DAUXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE65KKK80DATXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE65KKKN700CTXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE65KKKN800DTXXU
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | KKKE65KKKN90DATXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE65KKKN95DATXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE65S90DATXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE65S95DATXXU
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | KKKE75KKK60DAUXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE75KKK70DATXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE75KKK80DATXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE75KKKN700CTXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE75KKKN800DTXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE75KKKN85DBTXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE75KKKN900DTXXU
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | KKKE75KKKN95DATXXU
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | KKKE83S90DAEXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE85LS03DAUXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE85KKK60DAUXXU
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | KKKE85KKKN800DTXXU
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | KKKE85KKKN900DTXXU
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | KKKE98KKK80CATXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE98KKKN90DATXXU
 |  |  |  |  |  |  | A0S430A240032235 | KKKE98KKKN990CTXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE55DU7100KXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE55DU8000KXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE55DU8500KXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE65DU7100KXXU
 |  |  |  |  |  |  | A0S430A240032235 | [NAME]
 |  |  |  |  |  |  | A0S430A240032235 | UE65DU8500KXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE70DU7100KXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE75DU7100KXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE75DU8000KXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE75DU8500KXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE85DU7100KXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE85DU8000KXXU
 |  |  |  |  |  |  | A0S430A240032235 | UE98DU9000UXXU
 |  |  |  |  |  |  | - | BLANK
 |  |  |  |  |  |  | - | BLANK
 |  |  |  |  |  |  | - | BLANK
 |  |  |  |  |  |  | A0S430A240032228 | [NAME]
 |  |  |  |  |  |  | A0S430A240032228 | KKKE32KKK50AEUXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE43LS01BGUXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE43LS01BHUXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE43LS01DAUXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE43LS03DAUXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE43LS05BGUXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE43KKK60DAUXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE43KKKN90DATXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE48S90DAEXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE50LS01BGUXXU
 |  |  |  |  |  |  | A0S430A240032228 | [NAME]
 |  |  |  |  |  |  | A0S430A240032228 | KKKE50LS01DAUXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE50LS03DAUXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE50KKK60DAUXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE50KKK80DATXXU
 |  |  |  |  |  |  | A0S430A240032228 | KKKE50KKKN90DATXXU
 |  |  |  |  |  |  | A0S430A240032228 | UE43DU7100KXXU
 |  |  |  |  |  |  | A0S430A240032228 | UE43DU8000KXXU
 |  |  |  |  |  |  | A0S430A240032228 | UE43DU8500KXXU
 |  |  |  |  |  |  | A0S430A240032228 | UE50DU7100KXXU
 |  |  |  |  |  |  | A0S430A240032228 | UE50DU8000KXXU
 |  |  |  |  |  |  | A0S430A240032228 | [NAME]
 |  |  |  |  |  |  | A0S430A240032229 | KKKE50KKK80DATXXU
 |  |  |  |  |  |  | A0S430A240032229 | KKKE50KKKN90DATXXU
 |  |  |  |  |  |  | A0S430A240032229 | UE43DU7100KXXU
 |  |  |  |  |  |  | A0S430A240032229 | UE43DU8000KXXU
 |  |  |  |  |  |  | A0S430A240032229 | UE43DU8500KXXU
 |  |  |  |  |  |  | A0S430A240032229 | UE50DU7100KXXU
 |  |  |  |  |  |  | A0S430A240032229 | UE50DU8000KXXU
 |  |  |  |  |  |  | A0S430A240032229 | [NAME]
 |  |  |  |  |  |  | A0S430A240032229 | KKKE50KKK80DATXXU22
 |  |  |  |  |  |  | A0S430A240032229 | [NAME]
 |  |  |  |  |  |  | A0S430A240032229 | UE43DU7100KXXU22
 |  |  |  |  |  |  | A0S430A240032229 | UE43DU8000KXXU22
 |  |  |  |  |  |  | A0S430A240032229 | UE43DU8500KXXU22
 |  |  |  |  |  |  | A0S430A240032229 | UE50DU7100KXXU22
 |  |  |  |  |  |  | A0S430A240032229 | [NAME]
 |  |  |  |  |  |  | A0S430A240032229 | [NAME]