VLOOKUP, HLOOKUP and XLOOKUP: one practical Excel example
A formula can return a number and still point to the wrong product. I walk through a small product lookup, then deliberately break the data to show what needs checking.
Knowledge base / Excel
Excel: functions with examples
Excel functions grouped by task: lookups, conditional counting and summing, dates, text and dynamic arrays.
100 entries
This section covers the Excel functions that matter most in data analysis: lookups, conditional counting, dates, text and dynamic arrays. The grid below groups them by the job they do, so you can find a function even if you only know what you want to achieve.
Excel uses the list separator from your regional settings. English versions usually separate arguments with commas, while many European locales use semicolons and a decimal comma. If a formula copied from a tutorial returns an error, check the separator first.
If you are just starting, begin with the “Lookup and reference” and “Counting and summing” groups. A larger example that combines several lookup functions is in the article VLOOKUP, HLOOKUP and XLOOKUP.
Lookup and reference 7
Counting and summing 12
Conditions and value checks 12
Text 17
Dates and time 18
Maths and rounding 27
Dynamic arrays and other 7
No matching entries. Try a shorter name.
Articles that go further
Array formulas in Excel: from one cell to a complete list
One formula can calculate six values, select matching rows or create a list of categories. I explain how to predict its output and catch mistakes before they reach a report.
Advanced Excel formulas: calculations, lookups and error checks
A useful formula produces a result you can explain and verify. I use six records to connect calculations, lookups and text processing in a readable worksheet.
How Power Query works: from a raw file to a repeatable process
Power Query remembers how to prepare data. I explain what it repeats, how to verify the result and why a new source file can still require a change to the rules.
