Quote Originally Posted by xld
Try this formula

=IF(OR(D1="Building",D1="Electrical",D1="Heating and Ventilation",D1="Air Conditioning",D1="Window Blinds"),Building,"Please enter Description")
But that wouldn't include my lists HandV, Electrical, AirCon and WindB, would it?