Monday, November 19, 2012

yogi_Lookup Group Name Row By Row From A LookUp Table

                                          Google Spreadsheet   Post  #875
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 19, 2012
user Houman said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/3LwMpWxRhnQ)
IF function formula
 I'm looking to create a nested IF function.

Here is an example


We have
Jack, Age 6
Jill, Age 13
Bill Age 18
Martha Age 26
Jeremy Age 64
and there are several groups
If your aged between

5-10
Your group Apple
10-15
Group Banana
15-20
Group Coconut
20-30
Group Dog
30-300
Group Elephant

So i would want the spreadsheet to realise Jack is 6 years old and belongs in the group apple, jeremy for elephant and so on.

If anyone could provide me with the formula of how to do this I would be very grateful.
-----------------------------------------------------------------------------
following is a solution to the problem