If statement...copy values of cells on another worksheet.

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

Guest

I need a formula that looks at a drop down list on a different worksheet and
if it is "Sold", then the data values from T2:AC2 would show up on the other
worksheet. Is this possible?
 
I still need help. I need it to look at S2:S86 (drop down list), if it is
"Sold", then T2. I beleive I have to write a formula for each cell based on
the "Sold" cell for the other values to AC2. So, my problem is getting a
formula to look at S2:S86.
 

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 with a drop down list 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Formula 1
Getting data from another worksheet 2
Excel VBA 1
Drop Down List from one worksheet to another 5
Paste Values in linked Cells Only 4
Summing up various Worksheets to one Summary sheet using variables 1

Back
Top