Using Lookup

M

Matt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top