If statement with a drop down list

[heater]

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.

[heater]

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.
>