Populate a cell with information that is based on 2 items in the spreadsheet.

Hello,

I run a youth sport program in which our divisions are based on age and weight. I am trying to automatically designate a players division based on those two criteria. The age and weights are as follows:

AGE Max Weight Division
6 Unlimited Mighty Mite
7 Unlimited Mighty Mite
8 70 Mighty Mite
8 105 Bantam
8 Unlimited Bantam
9 100 Bantam
9 130 Junior
9 Unlimited Junior
10 75 Bantam
10 120 Junior
10 140 Junior 1
10 Unlimited Junior 1
11 100 Junior
11 130 Junior 1
11 150 Junior 2
11 Unlimited Junior 2
12 110 Junior 1
12 140 Junior 2
12 200 Senior
12 Unlimited Senior
13 120 Junior 2
13 190 Senior
13 Unlimited Senior
14 185 Senior
14 Unlimited Senior


So, for example, if in the spreadsheet the child's age is 13 and they weigh 130 lbs, the division column would show "Senior" as the player is 13 and weighs more than the 120 lb max required to play in the Junior 2 division.

I know this is possible but I just cant wrap my mind around it.

Thanks for your help!

Hi gdub23
try this layout

Had this yesterday and held it back until post was fixed.

[EDIT}

Changed F3 to "Mini Mite" to demonstrate use.