In a Google Docs spreadsheet I have two tables:Date        BMI     BMI Outcome 2011-06-21  22.1    ?2011-06-22  21.8    ?2011-06-23  21.5    ?andName                    From    ToSeverely underweight            15.99Underweight             16      18.49Normal                  18.5    24.99Overweight              25      29.99Obese Class I           30      34.99Obese Class II          35      39.99Obese Class III         40A blank value in From is assumed to be 0 and a blank value in To is assumed to be infinity.I want to write a formula to enter into the BMI Outcome column of the first table that will take the value from the BMI column, and look up the corresponding Name from table 2 for whichever From-To range the BMI value lies between.So for example the 22.1 column should have an outcome of 'Normal'.
In Google Spreadsheets how do I select column 1's value if an input value is between the integers in colums 2 and 3 for a range?
google spreadsheets;worksheet function