![]() |
#1
|
|||
|
|||
![]()
On sheet of a work book I have column C set up to perform a data validation and users must select from a drop down. I am trying to write an if statement that keys off of what is selected in the drop down.
my formula is Code:
=IF(C2="A", (Sheet4!J1), IF(C2="B", (Sheet4!J2), IF(C2="C",(Sheet4!J3), IF(C2="D",(Sheet4!J4), "")))) |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
Edit Points in Curve: MS Office changes points properties itself, without my action. | Sergey SPb | PowerPoint | 0 | 08-27-2012 05:33 AM |
Chosen option of drop-down changes another cell content | Weed | Word | 1 | 01-26-2012 02:44 PM |
Drop down box in a cell | Grapejuice | Excel | 0 | 10-22-2007 07:40 PM |