=IF(D1="Building",Building,IF(D1="Electrical",Electrical,IF(D1="Heating and Ventilation",HandV,IF(D1="Air Conditioning",AirCon,IF(D1="Window Blinds",Blinds,"Please enter Description")))))
I know, I don't know why, but it's not working for me! Any ideas?