Help with multiple dependent drop down lists

First off, HUGE thanks to all you gurus of excel and the abundance of information on this site. This is the first time in years I haven't been able to solve my own excel problems searching through threads, google, etc. So with that, someone please hit me with some excel knowledge!

I've inherited a T-shirt order form and was trying to make the sheet a bit more user friendly with drop-downs, etc. The basic problem comes in here. There are 3 different shirt styles, men and women options, with specific size and color options for each style and an associated price tag.

I'm pretty familiar with Data Validation and defining names of cell ranges but couldn't quite make the sheet work beyond getting to column D with the size drop down. Would like to see the color options drop down work as well as the price automatically fill in based on the conditions (I could probably figure this out with a lookup function but im sure someone has a better option)

Anyways, enough with talking. Help? Thanks in advance. Sheet attached. Specific shirt information starts at B49


NOTE: I started building a second sheet thinking there may be a better way to lay things out.

EDIT-Updated excel sheet

Create multiple linked dropdown list in excel

http://helpdeskgeek.com/office-tips/...ists-in-excel/

http://thefinch.wordpress.com/2008/0...datavalidatie/

http://www.contextures.com/xlDataVal02.html

http://www.snb-vba.eu/VBA_Afhankelijke_validatie.html also in Englisch

Thanks oeldere! I looked at a few of those and they didnt quite fit with what i was trying to do.

I kept toying around a bit and wrote this as the data validation formula and it seems to work for providing the correct color options.

Please Login or Register  to view this content.

Still toying with how to make the price autofill based on Columns B-D