If statement with a drop down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement...copy values of cells on another worksheet. 2
creating nested formulas from drop down box 5
Conditional Formating with IF and AND formula 2
Help with a range formula 4
Filtered drop down list 2
Easier way to concatenate a row? 8
Need help with a project sheet, need date to show/not show based o 4
Conditional Sum date range 2

Back
Top