Using Lookup
 

I'm working on making a spreadsheet that will determine if individuals meet
height/weight requirements. I need an output indicating if the weight
(given the age and height) is above the minimum and below the maximum.
Below is a portion of the chart being used.

HEIGHT MINIMUM MAX MAX MAX MAX
(MALE) AGE 17 - 20 AGE 21 - 27 AGE 28 - 39 AGE 40 +

58 91
59 94
60 97 132 136 139 141
61 100 136 140 144 146
62 104 141 144 148 150
63 107 145 149 153 155

Thanks for your help