Thread: Using Lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Matt is offline
external usenet poster
 
Posts: 516
Default 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