Blog
Practical Excel, Power Query and Power BI solutions
Useful articles on Excel, Power Query, Power BI and Report Automation – from simple formulas to fully automated reports.
Learn to join Excel tables with XLOOKUP
A clear, practical example of how to use XLOOKUP quickly and without errors.
-
How to Find the Last Match with XLOOKUP in Excel Tables
Learn how to use XLOOKUP with search_mode = -1 to find the last match in an Excel table instead of…
-
How to Automate Merging Excel Tables with XLOOKUP
Learn how to automate merging Excel tables with XLOOKUP – reduce manual work and the risk of errors in repetitive…
-
How to Merge Excel Tables from Different Files with XLOOKUP
Learn how to merge Excel tables from different files using XLOOKUP. Practical example, common mistakes, and tips to avoid errors.
-
How to Check Whether Your XLOOKUP Results Are Correct
Learn how to check whether your XLOOKUP results in Excel are correct. COUNTIF verification, duplicate detection, and common mistakes.
-
XLOOKUP vs VLOOKUP: What’s the Difference and Which One to Use
Learn the difference between XLOOKUP and VLOOKUP in Excel tables and which function to use in your situation. Key differences…
-
XLOOKUP Not Working? 3 Common Causes and How to Fix Them
Learn the 3 most common reasons why XLOOKUP doesn’t work in Excel tables – spaces, mismatched formats, duplicate IDs –…
-
How to Merge Excel Tables by ID Using XLOOKUP
Learn how to merge two Excel tables using a shared ID column with XLOOKUP. Simple merging logic and a practical…
-
VLOOKUP Not Working? 3 Common Mistakes and How to Fix Them
Learn the 3 most common VLOOKUP mistakes in Excel tables – wrong column numbers, breaking formulas, left-side lookups – and…
-
Why It’s Worth Switching from VLOOKUP to XLOOKUP in Excel
Learn why it’s worth switching from VLOOKUP to XLOOKUP in Excel tables – fewer errors, simpler syntax, and more reliable…