| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If statement with a drop down list
I need a formula that looks at a drop down list in S2:S86 on a different
worksheet and if it is "Sold", then the data values from row Q2:AC2 and so on down each row to Q86 would show up on the other worksheet. I beleive I have to write a formula for each cell based on the "Sold" cell for the other values from Q2:AC2. So, my problem is getting a formula to look at S2:S86. I tried =IF(Deals!$S2:$S86="Sold",Deals!T2), but the result is FALSE. |
| 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 | |||
| Drop down list with an if statement | Excel Worksheet Functions | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| Drop List Referencing | Excel Worksheet Functions | |||
Threaded Mode
