Spreadsheet: 218608d1362508048-looking-up-a-value-in-a-range-this-should-be-easy-excel-forum-upload-5-march-2013
Sheet: Combined Bod Types-Zag Def

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (if(and(Y3>.75, X3>.75), "Apple", IF(and(X3>1.25, Y3>.75), "Pear", if(and(Z3<2.1, Y3<.75), "Hourglass", if(and(Y3>.75, X3>.75), "Column", if(and(X3>,.75), "Upper Figured Shape", "")))))
 |  |  |  | Bust | Waist | Hips | Height | Inside Leg Length | Thigh | Lower Thigh | Bicep | Wrist | Front Shoulder To Waist | Waist To Hip | Back Neck To Tail Bone |  | Waist to Hip | Bust Less Hips |  |  |  |  |  |  |  |  | Wasit to Hip | Waist to [NAME] | Hip to Waist | Bust less Hips | Bust to Waist | Body Type | Hips Size | [NAME]
 |  |  |  | 35 | 25 | 36 | 64 | 31.69291338582677 | 19.68503937007874 | 16 | 11.02362204724409 | 5.511811023622047 | 18.89763779527559 | 6.692913385826771 | 27.16535433070866 |  |  |  |  |  |  |  | Apple |  |  |  |  |  |  |  |  |  |  |  |  |  | Apple |  |  |  | index(Sizes!$A$4:$A$16, SUMPRODUCT((--('Combined [NAME] Defined'!C7<=Sizes!$C$4:$C$16), --('Combined [NAME] Defined'!C7>=Sizes!$B$4:$B$16, row()))+
 |  |  |  | 32 | 27 | 36 | 64 | 29.52755905511811 | 18.89763779527559 | 13.77952755905512 | 9.84251968503937 | 5.511811023622047 | 14.56692913385827 | 8.661417322834646 | 23.62204724409449 |  |  |  |  |  |  |  | Pear |  |  |  |  |  |  |  |  |  |  |  |  |  | Upper Figured Shape
 |  |  |  | 33 | 26 | 36 | 60 | 29.52755905511811 | 18.89763779527559 | 13.77952755905512 | 9.84251968503937 | 5.511811023622047 | 14.56692913385827 | 8.661417322834646 | 23.62204724409449 |  |  |  |  |  |  |  | Hourglass |  |  |  |  |  |  |  |  |  |  |  |  |  | Column
 |  |  |  | 33 | 26 | 36 | 61.25 | 29.52755905511811 | 18.89763779527559 | 13.77952755905512 | 9.84251968503937 | 5.708661417322834 | 14.56692913385827 | 8.661417322834646 | 23.62204724409449 |  |  |  |  |  |  |  | Ruler
 |  |  |  | 32 | 29 | 36 | 63 | 33.07086614173228 | 22.04724409448819 | 18.11023622047244 | 10.23622047244094 | 5.708661417322834 | 12.59842519685039 | 5.511811023622047 | 24.01574803149606 |  |  |  |  |  |  |  | Cone
 |  |  |  | 32 | 29 | 36 | 64 | 33.07086614173228 | 22.04724409448819 | 18.11023622047244 | 10.23622047244094 | 5.708661417322834 | 12.59842519685039 | 5.511811023622047 | 24.01574803149606
 |  |  |  | 32 | 29 | 36 | 65 | 33.07086614173228 | 22.04724409448819 | 18.11023622047244 | 10.23622047244094 | 6 | 12.59842519685039 | 5.511811023622047 | 24.01574803149606
 |  |  |  | 40 | 31 | 42 | 67 | 33 | 21 | 18 | 11 | 6 | 24 | 10 | 35
 |  |  |  | 38 | 31 | 37 | 68 | 29 | 21.5 | 16.5 | 11 | 5.5 | 12 | 6 | 22
 |  |  |  | 37 | 30 | 38 | 60.62992125984252 | 30 | 16 | 13 | 12 | 5.5 | 15 | 6 | 25.5
 |  |  |  | 37 | 30 | 38 | 62.99212598425197 | 30 | 16 | 13 | 12 | 5.5 | 15 | 6 | 25.5
 |  |  |  | 37 | 30 | 38 | 65.94488188976378 | 30 | 16 | 13 | 12 | 7 | 15 | 6 | 25.5
 |  |  |  | 36 | 30 | 35 | 65.94488188976378 | 31 | 20 | 18 | 11 | 6 | 17 | 9 | 20
 |  |  |  | 36 | 29 | 34 | 66.92913385826772 | 30 | 21.5 | 18 | 10 | 5.905511811023622 | 18 | 4 | 19.5
 |  |  |  | 36 | 27 | 29 | 66.92913385826772 | 31.49606299212599 | 15.74803149606299 | 13.77952755905512 | 9.84251968503937 | 6 | 14.56692913385827 | 11.02362204724409 | 15.74803149606299
 |  |  |  | 36 | 32 | 34 | 67.32283464566929 | 31 | 22 | 18 | 10 | 5 | 11 | 8 | 20
 |  |  |  | 35 | 28 | 33 | 67.32283464566929 | 34 | 25 | 19 | 9 | 5 | 11.81102362204724 | 3.149606299212598 | 14.17322834645669
 |  |  |  | 35 | 28 | 33 | 67.32283464566929 | 34 | 25 | 19 | 9 | 5 | 11.81102362204724 | 3.149606299212598 | 14.17322834645669
 |  |  |  | 35 | 28 | 33 | 67.71653543307086 | 34 | 25 | 19 | 9 | 0 | 11.81102362204724 | 3.149606299212598 | 14.17322834645669
 |  |  |  | 34 | 32 | 36 | 68.11023622047244 | 0 | 0 | 0 | 10 | 3.937007874015748 | large | medium | Large
 |  |  |  | 34 | 27 | 37 | 16298.03149606299 | 32 | 24 | 21 | 15 | 4 | 17 | 10 | 30
 |  |  |  | 34 | 28 | 34 | 16299.6062992126 | 28 | 12 | 8 | 8 | 3.937007874015748 | 13 | 6 | 21
 |  |  |  | 34 | 27 | 37 | 65.74803149606299 | 32 | 24 | 21 | 15 | 6 | 17 | 10 | 30
 |  |  |  | 32 | 30 | 36 | 67.32283464566929 | 30 | 21.5 | 16.5 | 11 | 6.5 | 19 | 7 | 23
 |  |  |  | 32 | 29 | 36 | 67.32283464566929 | 31 | 21 | 17 | 9 | 6.5 | 17 | 8 | 26
 |  |  |  | 32 | 29 | 36 | 68.11023622047244 | 31 | 21 | 17 | 9 | 5.905511811023622 | 17 | 8 | 26