Ahh I see what you are saying.
Sorry misread your post
yup that would return the first value from a list
Try this I used a nested if statement in the drop down list setup
I named the first list "team" the second list "Type' and the third list "number"
Depending on the value I select in Column F (a list) I will get a different list to pick from