Example of using VLOOKUP in Excel to match data between two tables based on a common column.
Two tables in Excel showing a "Main table" with Seller, Product, and Amount columns, and a "Lookup table" with Seller and Amount columns, connected by a common column (Seller) using a VLOOKUP function.