It's an underwriting table. So for example, a male smoker age 50 with "mild"
tobacco use would warrant an additional rating factor of 100, but a male
smoker age 55 with mild tobacco use would warrant an additional rating factor
of 110. Note that the second gentleman is 5 years older.

I have a chart which gives you the rating factor based on age, gender, and
mild/moderate/heavy use. Instead of having the user have to look up the
rating factor on the chart and enter it (lots of room for user error), I was
hoping to have them just enter the gender and age (which they have to do
anyway) and be able to select "Mild", "Moderate" or "Heavy" from a drop down
list. Ideally, as soon as they select "Mild", "Moderate" or "Heavy" from the
list, Excel will look at the Gender and Age fields and pull in the correct
Rating Factor from the chart. Hope that clears it up a little. I'm not
terribly familiar with Excel - obviously.

"charliedog" wrote:

I want to enter a value in one cell that will produce a result based on
values in other cells. For example: Cell B5 has a drop down list where I
select the level of Tobacco use (mild, moderate or heavy). Once I've selected
from the list, I want to return a value in C5 that reflects not only my B5
selection, but also the value in C1 (Gender - male or female) and C2 (age).
So if C1=Male, and C2=50, when I select "mild" in B5 I want C5 to show "100",
but if C2=55 then I want C5 to result in "110." I hope my description makes
sense. I would appreciate any help.