Home |
Search |
Today's Posts |
#1
|
|||
|
|||
drop-down list
hi all, I have a problem using a drop-down list. The problem is that I want to choose a value in the list, but the cell must also be updated by a formula. Let me explain by an example. Make a drop-down list in cell A1 of the days in a week: mon, tue, wed, thu, fri, sat, sun. In this way I can choose the day of the week manually, e.g. pick "mon" Now I want the cell A1 to automatically change its value in e.g. "wed" if I enter value 3 in cell B3; formula: =if(B1=3;"wed") How do I manage to link a formula as well as a drop-down list to the cell A1? Or isn't it possible with drop-down lists? Thanks in advance Wim -- wimpe ------------------------------------------------------------------------ wimpe's Profile: http://www.excelforum.com/member.php...o&userid=27657 View this thread: http://www.excelforum.com/showthread...hreadid=471740 |
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) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |