In this tutorial, you will learn how to perform a left join in Excel.
In order to keep and return every row from the left table, a left join is used to link two tables. Then, only those rows from the right table that have a matching value in a certain column are kept and returned.
Unfortunately, Excel does not include a function that can be used only for left joins. To conduct a left join, we can use additional tools, though.
Once ready, we’ll get started by utilizing real-world examples to show you how to perform a left join in Excel.
Table of Contents
Perform a Left Join in Excel
Before we begin we will need a group of data to perform a left join in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want to join the data together and become 1 table. To do so, we can use the VLOOKUP function. We will first copy the original data to another cell, then we will use the following formula =VLOOKUP(A2, $D$2:$F$8, {2,3}, FALSE).
Step 3
Once we are done, you will be able to perform a left join in Excel.
