Custom list based on value

[djg1991]

Hi guys, it's been a while since I've used Excel and now I'm racking my brains trying to remember how everything works.

Basically I would like a custom list in column B of the lineup sheet for all players in the squad sheet who match the given position. I would also like the age, overall and potential of the selected player to carry over to the lineup sheet.

I used to be able to do this kind of thing easily but I no longer work with Excel on a day-to-day basis and so I was hoping the kind folk on this forum may be able to point me in the right direction

Thanks in advance,

djg1991