If statement Question

[Joneye]

I have a blank cell F18, im looking for an IF formula to give me result if TRUE but it needs three answers based on the three options in E18 these are.

E18 (Dtop box with thelow options)

Monthly
Annual
Quarterly

No based on user choice I wish a number to appear in cell F18 Those options are below.

If Monthly is chosen result in F18 is 1
If Quarterly is chosen result in F18 is 3
If Yearly is chosen result in F18 is 12

<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">18</td><td style=";">Monthly</td><td style="text-align: center;;"></td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Method 1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E18</th><td style="text-align:left">Monthly</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F18</th><td style="text-align:left"></td></tr></tbody></table></td></tr></table><br />

 

[Peter_SSs]

Try

=IF(E18="","",LOOKUP(E18,{"Annual","Monthly","Quarterly"},{12,1,3}))

 

[Joneye]

GENUIS Peter,

Works a treat I did not want to use a table and index and match for this one.

Many thanks again...