Determine Age Group for each Race Participant

[Leigh Stewart]

My running group is hosting a race next weekend and my husband has volunteered me to work the finish line, specifically determining who wins each award. The awards are given to the first 3 finishers in each category which is determined by gender and age group (see attached example.) I've set up the Results spreadsheet in the attached to record bib numbers of the runners as they finish. Now I'm trying to create a formula that will look at the person's age and return the letter representing their Age Group. Then I can use that and the Gender to easily fill in the Awards chart to the right. What formula will compare the age of the person to the low and high values in the Age Group array and return the correct letter that represents their Age Group?

[martindwilson]

=LOOKUP(f3,$L$8:$L$14,$K$8:$K$14) will do for either male or female since the same bands apply

[Leigh Stewart]

You are FABULOUS!!!! Thank you so much!