Google Sheets Interchangeable Queries

This video displays how to create "InterChangeable Queries" in one tab of Google Sheets. In this example we have two datasets containing different fields/headers on two different tabs. The objective is to create one single query that allows the user to switch between the two datasets on the same Worksheet. This is achieved by utilizing "Named Ranges" along with the "Indirect Function." This allows the end user to create a "DropDown Selection" Menu to select which dataset is to be queried on. This lesson also illustrates how to create Column Selection Checkboxes specific to each dataset allowing the end user to display certain columns that pertain only to the current dataset being queried. 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 #googlesheetshacks #googlesheetstips #googlesheetsquery