Introduction
Lookups help you find matching information from one list to another. They connect related data so you don't have to copy or type it again. This saves time and reduces mistakes.
When you have a list of product IDs and want to find their prices from another table
When you want to match employee names with their departments from a separate sheet
When you need to pull customer contact details based on their order numbers
When you want to combine sales data with region names stored in a different table
When you want to check if a student ID exists in the attendance list and get their status