XLOOKUP, VLOOKUP or INDEX/MATCH? Big Lookup Functions Guide!

One of the most often used functions when creating an Excel model is consolidating data from different sources. Traditionally, there were 3 major functions for combining data from different tables or worksheets: VLOOKUP, SUMIFS and INDEX/MATCH. Now, Microsoft has introduced XLOOKUP. So what is the difference between these four lookup functions and which one should… Continue reading XLOOKUP, VLOOKUP or INDEX/MATCH? Big Lookup Functions Guide!

XLOOKUP in Excel: Easily Solve all VLOOKUP Problems!

XLOOKUP in Excel

It seems as if Microsoft has listened to many complaints of Excel users and introduced a new formula: XLOOKUP. It’s supposed to improve all the disadvantages of the “traditional” lookup functions VLOOKUP, INDEX/MATCH and SUMIFS. This article describes in what case and how to use it. Please feel also free to download all example in… Continue reading XLOOKUP in Excel: Easily Solve all VLOOKUP Problems!

Case-Sensitive Lookups in Excel: 4 Methods (+XLSX-Download)

Case-Sensitive Lookups in Excel

By definition, the VLOOKUP formula is not case-sensitive. Case-sensitive means, that it matters if you use capital letters or small letters. For instance, a VLOOKUP search for “AAA” will return the same value as for “aaa” or “Aaa”. But in some cases, you want to differentiate between capital and small letters. So how do you… Continue reading Case-Sensitive Lookups in Excel: 4 Methods (+XLSX-Download)

Multi-Condition VLOOKUP and INDEX/MATCH (+Excel-Download)

Multi-Condition Lookups in Excel

There are many cases in which you want to conduct a lookup with several search criteria. As of now only the SUMIFS formula allows a multi-condition lookup. Unfortunately, SUMIFS only works for numeric values (including dates) as the return value. If you want to return text, there is no direct method. The good news: Both… Continue reading Multi-Condition VLOOKUP and INDEX/MATCH (+Excel-Download)

3D Lookups in Excel: How to Look up Values in 3 Dimensions!

The queen of lookups in Excel: The 3 way- or 3D lookup. Imagine this scenario: You have several Excel tables, each has rows and columns. Depending on your input values, you want to get the data from a specific cell from the right table, row and column. Such lookups are called 3D lookups or 3… Continue reading 3D Lookups in Excel: How to Look up Values in 3 Dimensions!

2D Lookups in Excel: 4 Easy Methods and Examples!

There are many cases in which you need a 2 dimensional lookup. That means, if you want to get a value from a specific row-column combination with neither rows or columns fixed. Unfortunately, the problem of a two way lookup comes up quite often. In this article we explore 4 methods of how to conduct… Continue reading 2D Lookups in Excel: 4 Easy Methods and Examples!

INDEX and MATCH: Great Alternative to VLOOKUP in Excel!

You’ve probably heard of the VLOOKUP formula in Excel, haven’t you? The VLOOKUP formula searches for a value in a column. Once found it returns another value from the same row. A combination of INDEX and MATCH serves the same purpose. It works slightly different and has therefore some advantages and disadvantages towards VLOOKUP.

Before you leave: Boost your Excel skills!Join thousands of Excel users & subscribe to the newsletter!
  • The best Excel tips, tricks and tutorials.
  • 1x per month.
  • No spam. Promised.
Welcome gift: Save a lot of time with my huge keyboard shortcut package.

Learn more