I am setting up a spreadsheet that I need help with. In the first column, I
want them to choose their name from a list of about 80 names. In the 2nd
column, I want them to choose their role from a list of 6 roles. In the next
3 columns, I want them to choose their mentors, but the list of choices is
determinant on what they chose for their role in the 2nd column.

Can anyone please help with how to set this entire spreadsheet up?

Thank You!