I'm working on a fantasy football spreadsheet and I want to use a drop down menu to do side by side matchup comparisons.
A2:A13 I have the team names, and from Columns B to N are their respective stats.
Is it possible to have a drop down menu, and based on which team I select, it show stats from B,C,D,E...N below it?

I've only gotten as far as creating a drop down menu. Is there a lookup function specific to this type of situation? Any help would greatly be appreciated.