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    Nov 19, 2012
user Houman said: (!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

Your group Apple
Group Banana
Group Coconut
Group Dog
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