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. |
#2
|
|||
|
|||
I came up with a solution looking at S2, T2, U2, etc. and wrote an If
function based on the drop down. When the answer matched the drop down, the result showed up on the other worksheet. Then I used Auotfilter to hide all the blank rows. "heater" wrote: 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. |
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 | |||
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 |