Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) |