Select item from dropdown list, item code is displayed in cell

[Meghan]

I need help with a spreadsheet problem.

I created a timesheet for users to track their hours with an in-cell
drop down for some of the values.
Currently, an user is able to use the in-cell dropdown to select a
time off code and the result is displayed in the cell. However, I
would like to have the user to see the full-name on the in-cell
dropdown, but have the abbreviated code display in the cell when
selected.
I have been unable to figure out how to do this, so any help would be
great!
I am trying to stay away from extra Excel components or macros, as I
like to keep this sheet easy for the end user.

Current:

A1: H
B1: S
C1: V

D1: user selects A1, B1, or C1 with in-cell drop down.

Data > Validation > Settings
Allow: List
Source: A1:C1
In-cell dropdown


Desired:

A1: Holiday
B1: Sick
C1: Vacation

A2: H
B2: S
C2: V

D1: user selects A1, B1, or C1 with in-cell drop down, and the result
is A2, B2, or C2

 

[Anders S]

Meghan,

Beats me how to do it. I assume "in-cell dropdown" is Data Validation.

However, in E1 you can enter

=HLOOKUP(D1,A1:C2,2,FALSE)

which will return H, S or V instead of Holiday, Sick or Vacation, if that's what
you want.

Regards
Anders Silvén

 

[Meghan]

Yes, I'm using Data Validation for an in-cell dropdown. I've
experimented with the LOOKUP functions, but they don't allow the user
to select a value (as far as I can tell). If I'm wrong, please let me
know