I have a form feeding a master spread sheet. From that master spreadsheet I want to import specific rows to other spreadsheets based on a single column cell. The column is age and the spreadsheets to feed are for age groups. The form field is type your age.This it what I am using to import rows for groups 0-2 and group 12-18.
=query(importrange("key","Youth Master List!B2:Q1000"),where col3 <=2")
=query(importrange("key","Youth Master List!B2:Q1000"),where col3 >=12")
The problem I am having is bringing info in for a group age range of 3-4 and also 5-11. I can't seem to figure out how to get the "where" to target these other age ranges.