Quote Originally Posted by xld
Nor did yours, did it?
Sorry, when I first put it up it was wrong. I did post the correction but you probably didn't see it. The formula is:

=IF(D1="Building",Building,IF(D1="Electrical",Electrical,IF(D1="Heating and Ventilation",HandV,IF(D1="Air Conditioning",AirCon,IF(D1="Window Blinds",WindB,"Please enter Description")))))