Spreadsheet Operations

Look up rows in File 2 by a key and append selected columns to File 1

Like VLOOKUP but return exactly one column with a custom fallback value

Match a value in one File 2 column, return a value from a different File 2 column

Keep all rows from File 1, merge matching columns from File 2 (SQL LEFT JOIN)

Keep all rows from File 2, merge matching columns from File 1 (SQL RIGHT JOIN)

Keep only rows that match in both files (SQL INNER JOIN)

Keep all rows from both files, merging where keys match (SQL FULL OUTER JOIN)