Quote Originally Posted by xld
Nor did yours, did it?
Sorry when I first put it up it was wrong, I did repost it but you probably didn't see it. It's this:

=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")))))