I need a little help with drop down boxes. I am working with baseball
statistics, and I can't seem to figure out how to do this. I want to
be able to select a player from a list of players and have his stat
line displayed as well. For example:

I want to have a drop down list where I can select a players name in
cell B2, and his stats will be displayed in cells: B3,B4,B5,B6 etc.


Any help would be greatly appreciated...


--
keeganr
------------------------------------------------------------------------
keeganr's Profile: http://www.excelforum.com/member.php...o&userid=33245
View this thread: http://www.excelforum.com/showthread...hreadid=530698

The simplest way is to use Data Validation (Option "List") in cell B2
and retrieve the data in cells B3, B4, etc. with VLOOKUP functions.

You can take a look to this post:
http://jldexcel.blogspot.com/2006/02...xcel-data.html


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=530698