Age Category: =IF(AND(C3>=1,C3<=12), "Children", IF(AND(C3>=18,C3<=25),"Youth",IF(AND(C3>=26,C3<=44), "Adult",""))) =VLOOKUP(B13,B2:I8,8,0)