Entering # to pick particular selection
I'm tracking the reasons given as to why overtime is being worked.
In the sheet I'm sending to the managers to fill out weekly, I'm providing a
list at the top of common reasons, i.e. vacation coverage, short staffed,
drawing labs, etc.
The choices will be labeled 1 through ? ....and will be listed in cells C1
Through C?
I'd like for them to be able to enter a number in a cell, and have the
explanation associated with that # to appear either in that cell (preferable)
or in the cell next to it.
For example, they type "2" in F12 and "vacation" appears either in F12 or G12
|