How to use XLOOKUP in Excel
Look up a product code and return its price, with a working example and a missing-value message.
Look up values, calculate totals and organize data with practical Excel formulas and troubleshooting guides.
Look up a product code and return its price, with a working example and a missing-value message.
Add approved costs for one project using two matching conditions.
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.
Subtract real Excel dates and choose whether to include both endpoints.
Clean leading, trailing and repeated spaces, including common nonbreaking spaces.
Keep your headings and identifiers visible while scrolling through a large worksheet.
Choose the columns that define a duplicate and remove repeated records safely.
Summarize project costs and refresh the result when the source data changes.
Use Data Validation to choose a status from a fixed list.
Use a conditional formatting formula to highlight overdue tasks.
Separate delimited text and preserve leading zeros in record codes.
Fit all columns to one page wide while allowing rows to continue onto more pages.
Narrow down a Ctrl+S crash by checking a local copy, Safe Mode and Office repair.