How do you merge queries in Google Sheets?
Power Query merge is a join between tables. Google Sheets offers XLOOKUP, VLOOKUP, INDEX MATCH, and QUERY with joins on keys. Choose the tool that matches your key columns and whether you need many columns back.
When to use it
Use XLOOKUP or QUERY joins when Excel merged lookup tables in Power Query.
When to skip it
Skip joins when a single imported table already includes the columns you need.
Better Sheets resources
Related Tutorials
Watch how Merge queries works
How to Merge Cells in Google Sheets
Related terms
XLOOKUP
XLOOKUP searches a lookup array for a key and returns a matching value from a return array. It handles left lookups, approximate match, and custom not-found text without INDEX/MATCH gymnastics.
Read guide →QUERY
QUERY runs a SQL-like statement against a range of cells and returns a new table of results. You pass a data range, a query string with SELECT, WHERE, ORDER BY, and optional headers. It is the fastest way to filter, sort, group, and pivot sheet data without helper columns.
Read guide →INDEX MATCH
INDEX MATCH is a two-function lookup pattern: MATCH finds the row or column position of a key, and INDEX returns the value from that position in another column. It predates XLOOKUP but remains common in legacy models and tutorials.
Read guide →IMPORTRANGE
IMPORTRANGE loads values from a range in another Google spreadsheet into your current file. You pass the spreadsheet URL or key plus a range string with an optional sheet name. After you grant access once, the link stays live and updates when the source changes.
Read guide →Done reading about Merge queries?
Membership unlocks 637+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.