"DK1314" wrote
In sheet 2, A1 is the dropdown which has been achieved by Validation.
A2 will be a variable contract value. This will be manually entered
line on line. A3 would be the result.
So what I want to do is pick an option from the drop down, enter any
number in A2 and then have the result of A2*whatever option is picked
from A1 displayed in A3.
So if we picked STD 5 Yr, we want whatever we enter in A2 to be
multiplied by 0.8.

Assuming the reference packages / pricing
are listed in Sheet1's cols A and B

In Sheet2,

Put in A3:
=IF(OR(A1="",A2=""),"",VLOOKUP(A1,Sheet1!$A:$B,2,0 )*A2)

As-is, the formula in A3 above can be copied across to return
correspondingly
for other DV selections/inputs in B1:B2, C1:C2, etc

A sample construct for the above is available at:
http://cjoint.com/?dkhZjed4ed
DK1314_newusers.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---