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

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

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
--
Sincerely, Michael Colvin


"carrera" wrote:

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

Worked like a charm Michael

Thanks!

"Michael" wrote:

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
--
Sincerely, Michael Colvin


"carrera" wrote:

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

Your welcome. Thanks for the response.
--
Sincerely, Michael Colvin


"carrera" wrote:

Worked like a charm Michael

Thanks!

"Michael" wrote:

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
--
Sincerely, Michael Colvin


"carrera" wrote:

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