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
On this page of the site you can watch the video online Google Sheets Join Query with a duration of hours minute second in good quality, which was uploaded by the user The Excel Cave 23 May 2021, share the link with friends and acquaintances, this video has already been watched 18,829 times on youtube and it was liked by 273 viewers. Enjoy your viewing!