id rather use a look up put all those in a list
somwhere out of sight or create a data sheet to refer to so
it goes
BA .............................................................BB
order type
Emergency...................................................E
Specialist Inspection: Asbestos........................F
Specialist Inspection: Roof..............................R
Specialist Inspection: Trace & Access...............T
Works..........................................................W
then use a look up
=vlookup(c3,ba:bb,2,false)
Bookmarks