need a dynamic source for data validation drop down lists

okay, i modified the code in your example to fit my example, however, the key column populates with 0's, and the available teams list also populates with 0's...i'm obviously missing something, but for i cant see what...
have included the modified workbook, haven't changed the dropdowns as yet, seeing as the data is not there to use

Sorry..attached old file,am attaching thenew one