| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If statement...copy values of cells on another worksheet.
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? |
|
#2
|
|||
|
|||
|
I figured it out.
"heater" wrote: 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? |
|
#3
|
|||
|
|||
|
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. "heater" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| How can i copy a group of cells in a row to a column? | Excel Discussion (Misc queries) | |||
| Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
| Return range of values on an "IF" statement | Excel Worksheet Functions | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Linear Mode
