Introduction
Lookups help you find matching information from one list and bring it into another. This is useful when you have data in separate tables and want to combine details without copying everything manually.
When you have a list of product IDs and want to add product names from another table.
When you track employee hours in one sheet and want to show their department from another sheet.
When you have sales data and want to add customer contact info stored separately.
When you want to match student scores with their names from a different list.
When you update prices in one table and want those prices to appear automatically in your sales report.