Thank you soooo much for your response. I have been attempting the VLOOKUP
as you said for the last couple of hours and I can't get it to work either.
I feel really stupid....



"Niek Otten" wrote:

You should use the VLOOKUP() function.
Look here for a tutorial:

http://www.contextures.com/xlFunctions02.html

Also, you should use short codes or abbreviations for your descriptions. It is too easy to make a typo now, which you demonstrate
in your question.

Post again in this thread if you can't get it done

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"klg" wrote in message ...
|I am developing a spreadsheet for us to use at for keeping track of bonuses.
| I have 7 columns - date, policyholder, policy, type, premium, bonus, and
| initials. The date, policyholder and premium columns we'll fill in. I have
| created dropdown boxes for the policy and type columns. I want the bonus
| column to fill itself based on either what is chosen in the type column or to
| calculate 2% of the premium, (depending on which it used), but I can't seem
| to make any function work.
|
| I tried the following formula for the type, but it didn't work.
|
| =IF(D5=CD/ASSISTED,CHECKING,CREDIT CARD,DECLINED/WORKED LOAN,MONEY
| MARKET,MUTUAL FUND ASSISTED,SAVINGS, "10.00", IF(D5=ANNUITY IRA/TSA
| ASSIST/REFERRAL,ASSURANT STUDENT,HOSPITAL INCOME,LOAN W/OUT CREIDT
| DISABILITY,MEDICARE SUPPLEMENT,MORTGAGE DISABILITY INCOME,TERM,
| "25.00",IF(D5= ANNUITY IRA/TSA,ASSURANT INDIVIDUAL MEDICAL,LOAN W/CREDIT
| DISABILITY,LONG TERM CARE,MORTGAGE LOAN CLOSED,UNIVERSAL LIFE,WHOLE LIFE,
| "50.00")))
|
| HELP!!