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
|