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.
-
10 Most Common XLOOKUP Problems and How to Fix Them | Excel Guide
Learn the 10 most common XLOOKUP problems in Excel tables – from #N/A errors to duplicate IDs – and how…
-
How to Return Multiple Columns at Once with XLOOKUP | Excel Example
Learn how to return multiple columns at once with the XLOOKUP formula in an Excel table. Practical example, common mistakes,…
-
How to Use XLOOKUP with Multiple Criteria in Excel Tables
Learn how to use XLOOKUP with multiple criteria (like ID and city) to merge Excel tables accurately. Practical example and…
-
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 –…