Jan 05 2021 05:23 AM
Jan 05 2021 05:26 AM
It looks like you need dependent drop-down list, sample is here Dependent Drop-down Lists in Excel - Easy Excel Tutorial (excel-easy.com) or you may google for much more posts.
Jan 07 2021 12:05 AM
Thank you for the file. I'd add the table somewhere in workbook which maps names and positions
better in separate sheet and you may hide it after the workbook is ready.
For the names we create drop-down list in data validation using first column of the name. Position will be picked-up by formula like
or you may use VLOOKUP() or XLOOKUP() or simple LOOKUP() if you are more familiar with them.