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.


--
frizzocki
------------------------------------------------------------------------
frizzocki's Profile: http://www.excelforum.com/member.php...o&userid=37830
View this thread: http://www.excelforum.com/showthread...hreadid=573841