How to use XLOOKUP in Excel
Look up a product code and return its price, with a working example and a missing-value message.
Excel, Word, PowerPoint and Outlook tutorials.
Clear steps. Visual examples. Practice as you go.
37 guides to explore and practice.
Look up a product code and return its price, with a working example and a missing-value message.
Leave the cover and contents unnumbered, then start the main document at page 1.
Add approved costs for one project using two matching conditions.
Build a contents list from heading styles and update it after edits.
Keep your headings and identifiers visible while scrolling through a large worksheet.
Compress pictures and review embedded media before sharing a presentation.
Choose the columns that define a duplicate and remove repeated records safely.
Identify empty paragraphs, page breaks and section breaks before removing them.
Narrow down a Ctrl+S crash by checking a local copy, Safe Mode and Office repair.
Summarize project costs and refresh the result when the source data changes.
Choose the slide range and output format before sharing your presentation.
Switch to widescreen and check the layout after resizing.
Find a product price by code and keep the lookup range fixed when copying the formula.
Classify a score, include the boundary value and handle an empty cell.
Count submitted records using a text condition.
Build a dynamic task list from a status selected in another cell.
Use Data Validation to choose a status from a fixed list.
Use a conditional formatting formula to highlight overdue tasks.
Fit all columns to one page wide while allowing rows to continue onto more pages.
Separate delimited text and preserve leading zeros in record codes.
Subtract real Excel dates and choose whether to include both endpoints.
Clean leading, trailing and repeated spaces, including common nonbreaking spaces.
Put a wide table on a landscape page while keeping the surrounding pages portrait.
Choose A4 paper and enter custom margins in centimeters.
Keep column headings visible when a table continues onto the next page.
Create personalized letters using names, departments and meeting rooms from a spreadsheet.
Record edits and accept or reject them during document review.
Use tabs to separate columns and paragraph marks to separate rows.
Save a PDF, select the required pages and check the final layout.
Apply consistent logos, fonts and layouts across a presentation.
See notes on your laptop while the audience sees only the presentation.
Set slide timing, choose a video resolution and check the exported playback.
Preserve the source theme when moving slides into another presentation.
Choose a send time and check the scheduled message in Drafts.
Create a sender rule and check how it interacts with your other rules.
Set a time range and choose what internal and external senders receive.
Add your name and contact details and choose signature defaults for each account.
Try a shorter search, such as “page numbers” or “SUMIFS”.