Down down filter populating data base information

[Statz]

I have 2003 Excel. I apologize if this question has been asked before as I'm sure it has.

I have some information that is on work sheet A. On work sheet B it's a more organized review type work sheet.

I want a drop down menu with a selection of certain categories that when I select a certain cateogry it will show me a group of other categories.

For example,

I click on the drop down and I have 5 different categories. Just use names for example.

Joe
Sam
Steve
James
Mike


I click on Joe. Once I click on Joe I get 2 columns of information that shows up with each column representing about 5 other frields.

So I click on Joe and this pops up:

Baseball $2000
Football $450
Soccer $500

etc..

I've done this before but it's been years. From what I remember it was not too difficult.

[Haseeb Avarakkan]

Make a list of Baseball, Football.... then SUMPRODUCT will do it. Please attach dummy file, so members can see your layout.