Try a vlookup.
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"carrera" wrote in message
...
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