Inner Join

Venn diagram of inner join between Current Worksheet and Joined Data, showing only the overlapping area highlighted

Inner Join returns the rows that exist in both the current data and the joined data. Removes all rows that do not have data in both the current data and the joined data.

In the example below, we are using Inner Join to join a customer information table with an order information table. We are using Customer ID, shown in columns CUST ID, as the Join Key. Only the rows with data in both tables are preserved. The rows with data from Customer ID 2, 4 and 6 are removed from the resulting table because they only exist in one of the original tables.

Example results of inner join showing rows removed if the Join Key value does not appear in both tables

Different Joins handle multiple matching values differently.

# of matchesLookupInner joinLeft outer join
0NULLRemove rowNULL
2+*Add rowsAdd rows