Google Sheets Query with Drop Down List Criteria

This video displays how to create a Query in Google Sheets where the criteria is based off a DROP DOWN LIST. In this example we have a data set of Loan Detail Information. One of the columns in the data set is Loan Type which contains 3 types of loans. The objective is to create a drop list containing these 3 loan types as well as a 4th option to pull back all records (all loan types).

Learn more about Google Sheets Functions with this Book at Amazon.
https://amzn.to/3HkHcGa

Buy the complete Google Workspace User Guide at Amazon:
https://amzn.to/3Hr9dLW

DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links


#GoogleSheetsQuery
#GoogleSheetsQueryDropDownList
#GoogleSheetsQueryTips