yes and no.... I've got that part... let me better explain my situation... I work for an a/c company and I'm making a spreadsheet that more or less looks like the following:

Vendor:
Air Conditioner:
Furnace:
Coil:

I want to be able to say if the within the vendor cell "Carrier" is chosen then only Carrier model numbers show up in each of the following cells. I can do this with one... but it gets tricky when I try to distinguish between Air Conditioners and Furnaces and Coils. Perhaps I need to have two distinguishing factors... if it is a Carrier unit and a Furnace then here is your list... If it is Carrier and an Air Conditioner then this list.