Google Sheets Join Query

Описание

This video displays a Query in Google Sheets that JOINS data from 2 different tables in one single set of results. This is achieved through the use of curley brackets in Google Sheets which allows the user to combine multiple ranges that are not always next to one another. In addition the VLookup Function nested within the ArrayFormula is utilized to "join" the 2 datasets/tables together based on a common lookup id column.

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


#GoogleSheetsQueryJoin
#JoinQueryGoogleSheets
#GoogleSheetsJoinTables