Hi all,
I'm trying to develop a rating worksheet for an insurance agency. The rating tables are broken down first by territory (group of counties) and then the premium is shown depending upon the class (group of specialties) and limits desired. So, for example, for Territory 1, I have a rating table with classes 1 through 8 and different limit selections across the top, complete with corresponding premiums, like so:
A B C D
Class 200/600 500/1MM 1MM/3MM
1 2000 4000 6000
2 2500 4500 6500
I've constructed a user input sheet that allows them to select the appropriate variables (county, limits, etc) from drop down boxes and then I have a hidden worksheet converting these selections to usable data from additional tables in the background, i.e.,
A B
Archer 1
Radiology 2
200/600 1
I can construct a vlookup/match formula to tell excel to match the class shown in B3 with the limits shown in B4 but I can't figure out how to make it first select the appropriate table depending upon the county selected in B2. In other words, I need excel to say "this is Archer county (B2) so go look at Range X rate table and then vlookup/match according to class(b3) and limits(B4) to return the right premium".
Any ideas?
Thanks so much
Kate
Bookmarks