In this video, I’ll demonstrate how you can use VLOOKUP to join data in separate tables.
In this worksheet, we have two tables. In the first table, we have order data. You can see we’ve got a date, customer id, product, and total.
In a second sheet, we have customer data. We’ve got first and last name, street, city, state and so on. And, because the id is in the first column, we can use VLOOKUP to extract all the data in this table to the right of the id.