| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop down list for IF equation
Hi Steve,
Is this what you seek? In a workbook on sheet1, i placed an active x combobox from the control toolbox over cell a3. On Sheet2 in cells a1:a3, I put a list of names then back on sheet1, I populated cells a4:a17 with names. and in cell c4, I entered this formula: =IF(A5=$A$4,"B","C") and copied down to cell c18. Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Threaded Mode
