I am creating a drop down filter system using QUERY function for a grant database. Since you cannot do multi-select drop downs, we had to make 3 columns of “focus areas” for each grant opportunity. I want to be able to select a focus area from the drop down and need to be able to search and match across those three columns to pull matching grants. Here is the formula:

I am creating a drop down filter system using QUERY function for a grant database. Since you cannot do multi-select drop downs, we had to make 3 columns of “focus areas” for each grant opportunity. I want to be able to select a focus area from the drop down and need to be able to search and match across those three columns to pull matching grants. Here is the formula:

I am creating a drop down filter system using QUERY function for a grant database. Since you cannot do multi-select drop downs, we had to make 3 columns of “focus areas” for each grant opportunity. I want to be able to select a focus area from the drop down and need to be able to search and match across those three columns to pull matching grants. Here is the formula:

I am creating a drop down filter system using QUERY function for a grant database. Since you cannot do multi-select drop downs, we had to make 3 columns of “focus areas” for each grant opportunity. I want to be able to select a focus area from the drop down and need to be able to search and match across those three columns to pull matching grants. Here is the formula:

I am working on using ImportHTML in a google sheet right now, and am using it to import data that is always 6 columns wide, but is dynamic in length:
Data