Entering # to pick particular selection

[Guest]

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

 

[Anne Troy]

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

www.OfficeArticles.com
www.MyExpertsOnline.com

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

 

[Guest]

Hi Carrera. Try this:

A B
Reason ID Reason
1 vacation coverage
2 short staffed
3 drawing labs

If you enter the value from column A in F1, enter in G1: =
VLOOKUP(F1,A$1$:B$4$,2,False)

F1 = Value being looked up
A$1$:B$4$ = Range - use the $$ for absolute reference for the range if you
are going to copy the formula.
2 = The column # in which the information being looked up resides.
False = You are looking for an "Exact" Match.

The Range must be sorted on column A in ascending order to get the correct
answer in G12. HTH

 

[Guest]

Worked like a charm Michael

Thanks!

Hi Carrera. Try this:

A B
Reason ID Reason
1 vacation coverage
2 short staffed
3 drawing labs

If you enter the value from column A in F1, enter in G1: =
VLOOKUP(F1,A$1$:B$4$,2,False)

F1 = Value being looked up
A$1$:B$4$ = Range - use the $$ for absolute reference for the range if you
are going to copy the formula.
2 = The column # in which the information being looked up resides.
False = You are looking for an "Exact" Match.

The Range must be sorted on column A in ascending order to get the correct
answer in G12. HTH

 

[Guest]

Your welcome. Thanks for the response.