Creating a formula for a spreadsheet

Question

Can someone create a formula that shows what award the person receives based on the table array to the right. If the Total doesn't fall into the guidelines the person does not receive an award.

	Salina South Proportional Body Development		Brawn, Brute,& Beast T-Shirt Awards
	Name	Weight	Bench	Clean	Squat	Total	Weight Class	Award		MALE	Brawn	Brute	Beast
1	Seth White	235	305	250	415	970	242	242		Weight Class
2	Ryan Stuart	170	200	175	325	700	181			105	420	530	600
3	Ryan Schafer`	280	300	250	450	1000	500			114	455	570	655
4						0	105			123	500	610	710
5						0	105			132	540	660	765
6						0	105			140	560	700	810
7						0	105			148	595	735	855
8						0	105			156	625	770	895
9						0	105			165	660	805	935
10						0	105			181	705	860	1005
11						0	105			198	740	910	1060
12						0	105			220	780	965	1120
13						0	105			242	795	990	1145
14						0	105			500	810	1010	1175

Answer 1

Does this do what you want? The formula in I3 is

=IFERROR(INDEX($L$2:$N$2, XMATCH(G3, INDEX($L$4:$N$16, XMATCH(H3, $K$4:$K$16), 0), -1)), "")