View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BaggieDan BaggieDan is offline
external usenet poster
 
Posts: 18
Default Validation List Question, Text in Cell DIffers to that Selecte

I thought so, looks like I'll just have to add an extra column, use vlookup
and make the full description 'disappear'.

Thanks again

"T. Valko" wrote:

I can not use a Macro due to IT issues


Can't be done without a macro.

--
Biff
Microsoft Excel MVP


"BaggieDan" wrote in message
...
Good Morning, Afternoon, Evening (Depending on where you are)

I have put together a TimeSheet that allows the user to select a type of
leave that a person may have, e.g. Annual Leave, Sick, Bereavement Leave
etc.


Currenty I have a list of names in columns and dates in rows and when a
person is on leave the user drops a list down and selects the relevant
leave.
However, what I want is rather than the whole word to appear e.g. Annual
Leave, I want a short code to appear e.g. A.L.


So the user sees the full description in the drop down list but all that
is
entered into the cell is the short code.

I can not use a Macro due to IT issues, I think if it can be done then it
is
the Data Validation function, but not too sure what to do then. Its
almost a
VLookup command but if you enter this in the cell and then create a drop
down
list you get a circular reference, which is not good!

I hope I have explained myself clearly enough and thank you in advance for
any help you can offer.