2D XLOOKUPs: How to use the new XLOOKUP for searching in two dimensions

The new XLOOKUP function in Excel not only offers great advanced features, but can be also used for 2D XLOOKUPs. Before XLOOKUP, the most common way for searching in rows and columns at the same time was INDEX/MATCH/MATCH. A combination of XLOOKUP and XLOOKUP can do the same. Let’s see how it works and explore… Continue reading 2D XLOOKUPs: How to use the new XLOOKUP for searching in two 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