I am attaching a registration spreadsheet. Currently I use a data validation drop down list to choose the category.
I am hoping to use the Gender and Age fields to auto-populate the Category field based on which category they fall into.
For example, if gender is male and age is 22 then the category field would auto-populate "Men - 19 - 29"
The categories are listed on the Data tab, but for easier reference, they are:
Men - 18 and Under
Men - 19 - 29
Men - 30 - 39
Men - 40 - 49
Men - 50 and Over
Women - 18 and Under
Women - 19 - 29
Women - 30 - 39
Women - 40 - 49
Women - 50 and Over
Thanks in advance for your help!
Bookmarks