software

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: www.excelforum.com/member.php...oamp;userid=33245
View this thread: www.excelforum.com/showthread...hreadid=530698
The simplest way is to use Data Validation (Option quot;Listquot;) in cell B2
and retrieve the data in cells B3, B4, etc. with VLOOKUP functions.

You can take a look to this post:
jldexcel.blogspot.com/2006/02...xcel-data.html--
jordun------------------------------------------------------------------------
jordun's Profile: www.excelforum.com/member.php...oamp;userid=33118
View this thread: www.excelforum.com/showthread...hreadid=530698