Need help with a worksheet

K

klg

A co-worker has been working really hard on this and has previously posted,
but she’s stumped. Here's our situation -

We need a spreadsheet for tracking bonuses. There will be 7 columns - date,
policyholder, policy, type, premium, bonus and initials. We'll fill in the
date, policyholder and initials columns. We created dropdown boxes for the
policy and type columns. Once we choose the Policy, we need the Type
dropdown list to be a dependent dropdown, (with only the associated "Types"
showing), and for the bonus to fill itself in based on the policy and type
chosen. Unless Fire or Auto is chosen, in which case we need it to calculate
2% of the premium we enter.

We have worked and worked on this and still can’t get everything to work.

We have tried the following formulas -

=OFFSET(PolicyStart,MATCH(B5,PolicyColumn,0)-1,1,COUNTIF(PolicyColumn,B5),1)

=IF(C5=â€â€,PolicyList,INDEX(PolicyColumn,MATCH(C5,TypeColumn,0)))

=SUM(E5*2%)

=vlookup(D6,A1:B3,2,FALSE)

=VLOOKUP(D5,Policies!C3:D23,2,FALSE)

And we have used the following informational links -

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

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

We have uploaded the file to:

http://www.savefile.com/files/1333831

Can anyone help us PLEASE?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help w/Validation List & VLOOKUP 9
Do I use "IF" or something else? 9
Bonus/Absence/Timesheet workbook help needed. 6
Need help - Complicated formula using multiple worksheets 3
help with a worksheet needed 3
Need to determine where a change in table occurs 6
Help with form design needed (Really struggling :-) ) 4
#n/a drving me mad, need to force ignore or remove them - Help! 5

Top