Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mask Drop Down List values
Hi all, Just a quick question, is it possible to mask the values in a validation drop down list? I'm using the indirect function in many of my formulas and wish the user to select the appropriate cell reference from a drop down list. Thus A-Z is placed into formulas using INDIRECT however I would rather more descriptive values in my drop down. Is this possible? Cheers -- DangerMouse ------------------------------------------------------------------------ DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755 View this thread: http://www.excelforum.com/showthread...hreadid=550961 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mask Drop Down List values
Hi
Create an additional sheet, p.e. MyList. On this sheet create a table like: Description, Char "First selection" "A" "Second selection" "B" .... "Last selection" "Z" Define named ranges DescrList=OFFSET(MyList!$A$1,1,,COUNTA(MyList!$A:$ A)-1,1) MyList=OFFSET(MyList!$A$1,1,,COUNTA(MyList!$A:$A)-1,2) Use named range DescrList as source for your data validation list, i.e. =DescrList Create named values (I assume the dropdown is p.e. in cell Sheet1!B1) MySelection=Sheet1!$B$1 MyChar=VLOOKUP(MySelection,MyList,2,0) Everywhere in your formulas you have to refer to MyChar. To avoid some confusion, it'll be best to hide the sheet MyList - no need for an user to see it. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "DangerMouse" wrote in message ... Hi all, Just a quick question, is it possible to mask the values in a validation drop down list? I'm using the indirect function in many of my formulas and wish the user to select the appropriate cell reference from a drop down list. Thus A-Z is placed into formulas using INDIRECT however I would rather more descriptive values in my drop down. Is this possible? Cheers -- DangerMouse ------------------------------------------------------------------------ DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755 View this thread: http://www.excelforum.com/showthread...hreadid=550961 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you make a drop down list in a drop down list? | Excel Discussion (Misc queries) | |||
drop down list help | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Refreshing drop down cell values... | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |