| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Statement using a Drop down box
I started witha dropdown box. The user will select one of the 3 conditions
(Balanced, Offensive, Defensive). Using that response the information inserted into other cells using predetermined data. What I have so far isn't working, I get a Naming error. =IF D1=F36,then display G35, else IF D1=F37, then display H35, else display I35 F36,F37, and F38 are the three choices in the drop down box and G35, H35 and I35 is the information I would like to put into my other cell. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement and Drop-Down | Excel Discussion (Misc queries) | |||
| Need to use if statement with drop down lists has this been done | Excel Worksheet Functions | |||
| adding a drop down list to an If Statement? | Excel Worksheet Functions | |||
| If statement with a drop down list | Excel Discussion (Misc queries) | |||
| Drop down list with an if statement | Excel Worksheet Functions | |||
Threaded Mode
