Thanks. Can you help me once more?
How do i copy the formula down about 80 rows?

"Henry" wrote:

You can do this with the LOOKUP function. You will need a table with the
values that are in the drop down list and their corresponding values. Here's
an example:

Put the drop down list items in column X (i.e. in X1 enter Mega 423, in X2
enter Primus 220, etc.)

In column Y, list the corresponding values for each (i.e. in Y1 enter 0.8,
in Y2 enter 1.2, etc.)

Assuming you have a total of 14 lines of data, you would then enter this
formula in cell F3: =lookup(E3,X1:X14,Y1:Y14)

One caution: The lookup function expects the items in column X to be in
alphabetical order. This may be a different order than in the drop down
list, but that doesn't matter, the two are not linked.

I think that should do it.

Henry

"Smarty" wrote:

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.