View Single Post
  #1   Report Post  
carrera
 
Posts: n/a
Default 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