Spreadsheet: 295618d1391754991-filter-multiple-columns-of-a-survey-data-as-per-defined-categories-example-v3
Sheet: Sheet2

Resp. id | Age | Employent | HH Income | [NAME] | Edn | Kids | Airline Trips | Living Alone | Age groups | Who Lives in HH -- I live alone Y/N (Flag 0-Yes Flag 1 - No) | Who Lives in HH -- I live with roommates (Flag 0-Yes Flag 1 - No) | Who Lives in HH -- I live with a significant other (Flag 0-Yes Flag 1 - No) | Who Lives in HH -- I live with my parents (Flag 0-Yes Flag 1 - No) | Who Lives in HH -- I live with my child(ren) (Flag 0-Yes Flag 1 - No) | Who Lives in HH -- Other (Flag 0-Yes Flag 1 - No) | Detailed segments | Output Desired I need to find data corresponding to categories defined in first sheet, from this table Hence I need to actegorize them first and create filters for High rich, rich, middle and youth and corresponding sub-categories. How to do this without creating separate columns for these 4 main categories and respective sub-categories..Is there any better way to do it where i can filter the data according to the parent categories and sub-categories in a single column...
 |  | FT/PT/Unemployed/Retired | 200000 | Single | School/High School/College | N | 4
 |  | FT/PT/Unemployed/Retired | 120000 | Married | School/High School/College | Y | 5
 |  | FT/PT/Unemployed/Retired | 160000 | Single | School/High School/College | N | 6
 |  | FT/PT/Unemployed/Retired | 170000 | Single | School/High School/College | N | 3 |  |  |  |  |  |  |  |  |  |  |  |  | Probably we can create a value tag for each cell and return its value in detailed segments and then include a vlookup to find the corresponding category from the below table if its satisfies certain conditions (or is there some other better way to do??)
 |  | FT/PT/Unemployed/Retired | 150000 | Married | School/High School/College | N | 6
 |  | FT/PT/Unemployed/Retired | 150000 | Single | School/High School/College | N | 5 |  |  |  |  |  |  |  |  |  |  |  |  | Category | HH Income | international 2 trips in last 12 months | [NAME] | [NAME] | Age | Retired | Student | Employment | Education
 |  | FT/PT/Unemployed/Retired | 100000 | Single | School/High School/College | N | 1 |  |  |  |  |  |  |  |  |  |  |  |  | High Rich
 |  | FT/PT/Unemployed/Retired | 130000 | Single | School/High School/College | Y | 7 |  |  |  |  |  |  |  |  |  |  |  |  | High Rich Travelers
 |  | FT/PT/Unemployed/Retired | 130000 | Married | School/High School/College | Y | 6 |  |  |  |  |  |  |  |  |  |  |  |  | Married
 |  | FT/PT/Unemployed/Retired | 110000 | Married | School/High School/College | N | 6 |  |  |  |  |  |  |  |  |  |  |  |  | Unmarried
 |  | FT/PT/Unemployed/Retired | 120000 | Single | School/High School/College | N | 7 |  |  |  |  |  |  |  |  |  |  |  |  | High Rich Non Frequent Travelers
 |  | FT/PT/Unemployed/Retired | 200000 | Married | School/High School/College | Y | 2 |  |  |  |  |  |  |  |  |  |  |  |  | With kids
 |  | FT/PT/Unemployed/Retired | 170000 | Married | School/High School/College | N | 2 |  |  |  |  |  |  |  |  |  |  |  |  | without kids
 |  | FT/PT/Unemployed/Retired | 180000 | Married | School/High School/College | Y | 7 |  |  |  |  |  |  |  |  |  |  |  |  | Married
 |  | FT/PT/Unemployed/Retired | 140000 | Single | School/High School/College | Y | 5 |  |  |  |  |  |  |  |  |  |  |  |  | Not Married
 |  | FT/PT/Unemployed/Retired | 110000 | Single | School/High School/College | Y | 4 |  |  |  |  |  |  |  |  |  |  |  |  | Rich
 |  | FT/PT/Unemployed/Retired | 140000 | Married | School/High School/College | Y | 6 |  |  |  |  |  |  |  |  |  |  |  |  | Rich Frequent Travelers
 |  | FT/PT/Unemployed/Retired | 160000 | Single | School/High School/College | N | 2 |  |  |  |  |  |  |  |  |  |  |  |  | Married
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unmarried
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rich Non Frequent Travelers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | With kids
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | without kids
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Married
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Married
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle (Medium)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle Families with kids in the HH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle Couples without kids in the HH (excluding retirees)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle Retirees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | College Going Youth
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Youth Workers (Not College Educated)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle Remaining
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Youth