IF AND Statement Problem

[candle_66]

I am trying to create a price list for my hobby poster website.

I can create drop down lists but want a IF(AND statement to auto fill depending on the size of poster selected.

I am trying to use =IF(AND(E3="Plak",M3=30),IF(E3="Mounted",M3=35),IF(E3="Print",M3=7.5,0))

Basically in cell M3 it should show 30 if Plak selected, 35 if Mounted selected and 7.50 if Print selected.

Am I missing something?
Any help much appreciated to get www.howzatposters.com up and running

Thanks

Howard

 

[Yogi Anand]

Hi Candle:

How about trying the following formula in cell M3 ...

=VLOOKUP(E3,{"Plak",30;"Mounted",35;"Print",7.5},2,0)

 

[candle_66]

Holy Smoley

Wot a numb nuts I am

I must be brain dead

Thank you very much.

regards

Howard (Candle_66)

 

[Yogi Anand]

Hi Howard:

You Are Very Welcome ... and don't be too hard on yourself ... now let us keep EXCELing!