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

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

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