Ill definitely be using a macro.

I recorder one that creates a validation for every row so you do one, Check the validation, Set the List box accordingly and move onto the next row. Repeat until you are finished

WorksheetTo_Test_Validation_From_Multiple_Ranges.xls