Drop down filtered lists

[_Flux_]

Hi can someone help me in the best way to do what I'm trying to achieve.

I want a set of drop lists to filter based on the previous selection. So using the example data below I want to be able to select a product, then the next drop down list is to be able to select a quantity based on the previous with a final cell entering the defined unit cost.

Product:				Quantity	Unit Cost
			Flyer A6	100	£30.00
Flyer A6				250	£36.00
Flyer A5				500	£42.00
Flyer A4				1000	£50.00
				2000	£63.00
				5000	£140.00
			Flyer A5	100	£30.00
				250	£42.00
				500	£62.00
				1000	£73.00
				2000	£125.00
				5000	£260.00
			Flyer A4	100	£40.00
				250	£61.00
				500	£95.00
				1000	£160.00
				2000	£245.00

<tbody>
</tbody>

Example:
I want Flyer A5 then to select 500 and it will automatically input the unit cost in the 3rd cell.

Product	Quantity	Unit cost
Flyer A5	500	£62.00

<tbody>
</tbody>

Any help is appreciated.

 

[dnorm]

If I am right in what you are after, then a simple filter will do just that.

Highlight all data and headings then add a filter, then just filter product, qty and you will be just left with the cost..

or are you wanting this information to be accessed from a different sheet?