How can i do the following with out creating another column
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
REGT MF2
REGT MF1
OVER MF2
OVER MF1
what i would like it to return would be
01-1613
01-1614
03-1616
03-1617
lets say I would like this validation in sheet 1 Q10
the name range for the list is called TASEmployeeActingCodeDescription the range i would like it to return is named TASEmployeeActingCodes
TASEmployeeActingCodeDescription is in(sheet 2 K2:K5000) TASEmployeeActingCodes is in(sheet 2 J2:J5000)
Can some one help me out with this?
I hope this makes sense
I know it can be done i just cant remeber how
<!-- / message --><!-- edit note -->
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
REGT MF2
REGT MF1
OVER MF2
OVER MF1
what i would like it to return would be
01-1613
01-1614
03-1616
03-1617
lets say I would like this validation in sheet 1 Q10
the name range for the list is called TASEmployeeActingCodeDescription the range i would like it to return is named TASEmployeeActingCodes
TASEmployeeActingCodeDescription is in(sheet 2 K2:K5000) TASEmployeeActingCodes is in(sheet 2 J2:J5000)
Can some one help me out with this?
I hope this makes sense
I know it can be done i just cant remeber how
<!-- / message --><!-- edit note -->