Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with IF and drop down lists on a look up
First problem is I want to place a n umerical value in a cell based on the
numerical value of another cell i.e if cell A1 contains a value =24 and <=35 then cell A2 should contain 250 if cell A1 contains a value =36 and <=59 then cell A2 should contain 500 I have tried using IF with &'s and using IF with AND but I can't get it to work. Also I want to put a drop down list in a box dependant on a text value in another cell for example if cell A1 contains ABC then drop down list (which I have placed on a separate sheet) will contain ab,cc,dd etc. Thanks loads |
#2
|
|||
|
|||
Try in A2
=if(and(A1=24,A1<=59),if(A135,500,250),"") "Macca" wrote: First problem is I want to place a n umerical value in a cell based on the numerical value of another cell i.e if cell A1 contains a value =24 and <=35 then cell A2 should contain 250 if cell A1 contains a value =36 and <=59 then cell A2 should contain 500 I have tried using IF with &'s and using IF with AND but I can't get it to work. Also I want to put a drop down list in a box dependant on a text value in another cell for example if cell A1 contains ABC then drop down list (which I have placed on a separate sheet) will contain ab,cc,dd etc. Thanks loads |
#3
|
|||
|
|||
There are instructions here for dependent data validation lists:
http://www.contextures.com/xlDataVal02.html Macca wrote: First problem is I want to place a n umerical value in a cell based on the numerical value of another cell i.e if cell A1 contains a value =24 and <=35 then cell A2 should contain 250 if cell A1 contains a value =36 and <=59 then cell A2 should contain 500 I have tried using IF with &'s and using IF with AND but I can't get it to work. Also I want to put a drop down list in a box dependant on a text value in another cell for example if cell A1 contains ABC then drop down list (which I have placed on a separate sheet) will contain ab,cc,dd etc. Thanks loads -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Symbols in Drop Down Lists | Excel Worksheet Functions | |||
Data Validation - Drop down lists - if then? | Excel Discussion (Misc queries) | |||
multiple drop down lists | Excel Discussion (Misc queries) | |||
Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) | |||
How do I change the appearance of my drop down lists? | Excel Worksheet Functions |