Drp down lists...
 

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

Drp down lists...
 

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