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