Hi there,

I would appreciate if somebody can help me with this simple looking query.

I have two columns. In First column user can select one team name from the
list of 5 defined teams. (Used Data-Validation-List)

In other column I want that the list of student names should be displayed
(for user to select) only belonging to the team selected in first cell.

Example:
Team Name Student Name
(allow user to see only students
listed in LAN team)
LAN A
B
C



Regards,
Shweta