Multiple drop down filtered quotes

Hi

I need to make a worksheet that works as a quote system.

On sheet 2 I'd have the data
productgroup productname productprice

On sheet 1 I'd have a quote template that i would build with drop down boxes I need to have product group as a drop down and product name as drop down then the price would be shown in the third field.

I've not seen any advice on how to do this exactly like stated, tutorials just seem to do one drop or usejust filters

Any advice on how I would do it? Thanks in advance.

Thanks Mark

It would help if you posted a small sample of what you are looking for