XLOOKUP #N/A practice workbook
10 messy payment IDs, diagnostics and the fixed formula.
Download .xlsx →Free weekly newsletter for people who use Excel at work
Fix one real Excel problem every week.
Lookup errors, messy CSV exports, monthly reports you rebuild by hand. Each issue takes one problem from your workday and fixes it step by step, with a practice file to try it on.
| A | B | |
|---|---|---|
| 1 | Invoice ID | Amount |
| 2 | 10482 | 860.50 |
| 3 | '10483 | #N/A |
| 4 | 10484 | 1,240.00 |
=XLOOKUP(TRIM(A3)*1, Data[ID], Data[Amount])Row 3 is text with a trailing space. The fix is one function away.
One problem per issue
Not a list of 20 tips. One problem from a real workday, explained so you can use it the same day.
The answer is in the email
No "click to read more" teasers. The steps, the formulas and the reason it works are all in the email.
Practice files included
Download a workbook with sample data and try the fix there before touching your own files.
Recent
Free practice files
Messy CSV + repair workbook
A UK-format export with dates, ZIP codes and long IDs that Excel breaks, plus repair formulas.
Download .xlsx →SUMIFS troubleshooting workbook
Broken and fixed date-range SUMIFS side by side, with hidden spaces in the data.
Download .xlsx →Free, weekly, and easy to leave
Unsubscribe from any email in one click. We never sell or share your address.