Simple Excel Formula Help

[BlueFunk3]

Hi,

I am new to Excel, but I am trying to expand my skills by producing a Formula.

What I aiming to do is the following,



I am creating a Recycable Spreadsheet, and I have cells with a drop list in them. I want to create a formula so if you select say Metal in Cell A, and the Material, say Aerosol in Cell B, then cell C chooses 'widely recycled, Check or Not recycled' from a drop list in Cell C.

I have tried the tutorials, but I cant seem to get it to work.

I am in Office 2011 for Mac, if that helps.

Cheers

Steve