I have one worksheet set as a database. In column A I have device types, for fire systems, smoke detectors, heat detectors and such. In column B I have the abbreveations for them.
I have another worksheet set up as an inspection report. Column A in that sheet is for the device types. I need drop down lists the show the whole name for the device, but I want it to enter the abbreveation when you select something.
So you click on the drop down and it refers to column A in the other sheet. Then you can choose, for example, Photo Electric Smoke Detector. Then it will enter the abbreveation from column B. Kinda makes it idiot proof. Huge plus with some of my guys.