Data Validation

S

Shweta Srivastava

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

list items from one table in another table based on value in first table 2
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Auto transfer data rows to other sheets when certain entries occur 7
Conditional List (auto filtered) 4
Data Validation mystery 2
Comapre columns 4
Hide column based on data validation 0
Conditional Validation 3

Top