XLOOKUP vs VLOOKUP: what actually changes in your work
VLOOKUP has three structural weaknesses that cause most lookup errors. XLOOKUP removes all three — here is exactly how, and what to do when your Excel version does not have it.
Practical writing on the same subjects as our courses: Excel technique, Power Query, Power BI, dashboard design, metric definitions and using AI assistants for analytical work without getting burned.
VLOOKUP has three structural weaknesses that cause most lookup errors. XLOOKUP removes all three — here is exactly how, and what to do when your Excel version does not have it.
The real test of a spreadsheet is not whether it works today, but whether a colleague can open it in eight months and change it without breaking it.
Nine structured courses with exercise files, from Excel fundamentals to published Power BI reports.