Drp down lists...

[keeganr]

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...

[jordun]

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