Listing based on Selection

Please have a look at the attached file.

There are two Manufacturers - Manu A and Manu B
Manu A has their own products with prices , same with Manu B.

I have a dropdown list at Cell D10. Which is in fact the list of Manufacturers (taken from the range F8:F9). What I would want is, When I select one of the Manufacturer from this list, D11 must automatically show the list of available products by that particular manufacturer. And then, once I selected a particular Model, then D12 must automatically get's its price.

For example; if the Manufacturer is MANU A ; then D11 must show the list from the range F14:F17. ; then once I select one from this list; then D12 must get it's correct price automatically from the range G14:G17

I guess, this wouldn't be hard for an expert, Conditional Listing or INDIRECT function etc may solve it easily. but people like me, a Newbie, wasting a lot of time searching and looking for a solution that supposed to be simple.

Thanks in advance.

You need depanted validation lists.

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