teri_carlson
Board Regular
- Joined
- Mar 17, 2006
- Messages
- 71
How can i do the following with out creating another collum
I know how to make a list using validation but i would like it to return a different value
I actually want it to retun the abrevation
so when they veiw the list to pick from they would see
Regular Time
Over Time (1.5)
Double Time
Absent
Late Arrival
Approved Time Off
what i would like it to return would be
REG
OT
DBLT
AB
LATE
ATO
lets say i would like this validation in sheet 1 C2
the name range for the list is called Type1 the range i would like it to return is named Abrev1
Type1 is in(sheet 2 A1:A15) Abrev1 is in(sheet 2 B1:B15)
Can some one help me out with this?
I hope this makes sense
I know it can be done i just cant remeber how
I know how to make a list using validation but i would like it to return a different value
I actually want it to retun the abrevation
so when they veiw the list to pick from they would see
Regular Time
Over Time (1.5)
Double Time
Absent
Late Arrival
Approved Time Off
what i would like it to return would be
REG
OT
DBLT
AB
LATE
ATO
lets say i would like this validation in sheet 1 C2
the name range for the list is called Type1 the range i would like it to return is named Abrev1
Type1 is in(sheet 2 A1:A15) Abrev1 is in(sheet 2 B1:B15)
Can some one help me out with this?
I hope this makes sense
I know it can be done i just cant remeber how
Last edited: