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.


[TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl63, width: 64"]Product:[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"]Quantity[/TD]
[TD="class: xl63, width: 64"]Unit Cost[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Flyer A6[/TD]
[TD="class: xl64"]100[/TD]
[TD="class: xl65"]£30.00[/TD]
[/TR]
[TR]
[TD]Flyer A6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]250[/TD]
[TD="class: xl65"]£36.00[/TD]
[/TR]
[TR]
[TD]Flyer A5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]500[/TD]
[TD="class: xl65"]£42.00[/TD]
[/TR]
[TR]
[TD]Flyer A4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]1000[/TD]
[TD="class: xl65"]£50.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]2000[/TD]
[TD="class: xl65"]£63.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]5000[/TD]
[TD="class: xl65"]£140.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Flyer A5[/TD]
[TD="class: xl64"]100[/TD]
[TD="class: xl65"]£30.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]250[/TD]
[TD="class: xl65"]£42.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]500[/TD]
[TD="class: xl65"]£62.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]1000[/TD]
[TD="class: xl65"]£73.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]2000[/TD]
[TD="class: xl65"]£125.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]5000[/TD]
[TD="class: xl65"]£260.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Flyer A4[/TD]
[TD="class: xl64"]100[/TD]
[TD="class: xl65"]£40.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]250[/TD]
[TD="class: xl65"]£61.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]500[/TD]
[TD="class: xl65"]£95.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]1000[/TD]
[TD="class: xl65"]£160.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl64"]2000[/TD]
[TD="class: xl65"]£245.00[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 215"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Quantity[/TD]
[TD] Unit cost[/TD]
[/TR]
[TR]
[TD]Flyer A5[/TD]
[TD="align: right"]500[/TD]
[TD]£62.00[/TD]
[/TR]
</tbody>[/TABLE]

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?