I am trying to create a formula that does the following:
Cell e3 is a drop down list with appro. 14 entries. I want cell F# to return
a value based on the entry i select in E3. eg. If I choose Mega 423 from the
drop down list i want 0.8 to appear in F3.
The same will apply for E4 as well, but I may choose Primus 220 which has to
return a result of 1.2. Can anyone advise.