Lookup functions mastery

Find a product's price from a product catalog using the product code.

Look up an employee's department using their employee ID.

Use HLOOKUP to retrieve a sales target for a specific quarter from a horizontal table.

Calculate shipping rate based on package weight using a tiered rate table.

Look up which city a customer is located in using their customer ID and a customer directory table.

Use XLOOKUP to find a product's category from a product catalog.

Use XLOOKUP to pull current stock quantities for items on a reorder list.

Return an ID from a column to the left of the lookup value using XLOOKUP.

Look up product info, returning "Discontinued" if product not found.

Use XLOOKUP with wildcard matching to find a product and price when you only know part of the product name.

Handle missing lookups with IFNA for VLOOKUP and the not_found argument in XLOOKUP.

Look up an employee's manager using INDEX-MATCH (lookup value not in first column).

Find a customer's email address where email is to the LEFT of customer ID.

Use INDEX with two MATCH functions to return a value from a shipping rate grid.

Find the price for a specific product in a specific quarter using nested XLOOKUP.

Look up a customer ID and return name, email, and phone in one formula row.