I
ivygirl
Hi all,
I'm trying to develop a rating worksheet for an insurance agency. Th
rating tables are broken down first by territory (group of counties
and then the premium is shown depending upon the class (group o
specialties) and limits desired. So, for example, for Territory 1,
have a rating table with classes 1 through 8 and different limi
selections across the top, complete with corresponding premiums, lik
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 th
appropriate variables (county, limits, etc) from drop down boxes an
then I have a hidden worksheet converting these selections to usabl
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 th
class shown in B3 with the limits shown in B4 but I can't figure ou
how to make it first select the appropriate table depending upon th
county selected in B2. In other words, I need excel to say "this i
Archer county (B2) so go look at Range X rate table and the
vlookup/match according to class(b3) and limits(B4) to return the righ
premium".
Any ideas?
Thanks so much
Kat
I'm trying to develop a rating worksheet for an insurance agency. Th
rating tables are broken down first by territory (group of counties
and then the premium is shown depending upon the class (group o
specialties) and limits desired. So, for example, for Territory 1,
have a rating table with classes 1 through 8 and different limi
selections across the top, complete with corresponding premiums, lik
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 th
appropriate variables (county, limits, etc) from drop down boxes an
then I have a hidden worksheet converting these selections to usabl
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 th
class shown in B3 with the limits shown in B4 but I can't figure ou
how to make it first select the appropriate table depending upon th
county selected in B2. In other words, I need excel to say "this i
Archer county (B2) so go look at Range X rate table and the
vlookup/match according to class(b3) and limits(B4) to return the righ
premium".
Any ideas?
Thanks so much
Kat