Data Validation - How to work with 2 Dynamic Lists where One list have Repetitive values.

Dear all,

Regarding Data Validation in Excel (2010).

Need your help in Data Validation to work with 2 Dynamic Lists where One list have Repetitive values.

= In the attached file, you will see =
" GradesNames " sheet has List of Grades(repetitive values) under " Grades " column; and List of Names(unique values) under " Names " column. Over the time, these two lists will increase in length.

" GradesNamesList " sheet should have Grade List at B1 and Name List at B2.

Appreciate any help on the same.

Thanks,
Vinod Krishna