XLOOKUP Function

### Excel Match Wildcard in Lookup Array (with 3 Formulas)

This article illustrates how to use excel formulas to match a wildcard in a lookup array. The three wildcards used in excel are the question mark ...

### How to Find Last Occurrence of a Value in a Column in Excel (5 Methods)

If you want to Find Last Occurrence of a Value in a Column in Excel, this article is for you. Here, we will walk you through 5 easy and handy ...

### How to Interpolate Between Two Values in Excel (6 Ways)

Data interpolation is a very important thing when we analyze an experiment or we want to predict or determine the results of an event. For instance, ...

### Applications of Absolute Structured References in Excel Table Formulas

In this tutorial, we will explain the applications of absolute structured references in excel table formulas. One thing you should know is that ...

### How to Extract Text After Last Space in Excel (5 Ways)

While using Excel, we often need to strip our text Cells and need part of our data, like the need of having the last part of the word of the long ...

### How to Change Drop Down List Based on Cell Value in Excel (2 Ways)

In order to extract specific data based on specific values, we may need to use the drop-down list. Moreover, we need to co-relate the two or more ...

### How to Do Linear Interpolation in Excel (7 Handy Methods)

Sometimes you may need to create a new data point from the given range of known data points. In such a situation, you might accomplish linear ...

### Vlookup with Multiple Criteria without a Helper Column in Excel (5 Ways)

Introducing helper columns to vertically lookup data always brings complexity. It also manipulates the raw data as additional data columns are ...

### How to Link Cells for Sorting in Excel (5 Methods)

Sometimes we have to link cells in Excel for sorting or various purposes. Typical linking of a cell requires inserting an Equal Sign (=) before a ...

### How to Use INDEX MATCH with Multiple Criteria for Date Range

Variables (such as commodity price, share, interest rate, etc.) subject to dates cause general people to panic, as their prices depend on dates. ...

### How to Find and Replace Using Formula in Excel (4 Examples)

This article will help you to understand the find and replace formula(s) in Excel. Sometimes we need to edit our data in Excel sheets and for that ...

### How to Find Last Non Blank Cell in Row in Excel (5 Methods)

It is not a matter of astonishment that we might face the requirement to find last non blank cell in row in Excel. Here, we will try to sort out some ...

### How to Find and Replace Multiple Words at Once in Excel (7 Methods)

Often we need to replace values. In this article, we've shown you 7 methods to find and replace multiple words at once in Excel. A company previously ...

### How to Create a Dynamic Top 10 List in Excel (8 Methods)

A top list is used to rank the companies or individuals based on values. This rank is set based on performance, quality, etc., or other criteria. In ...

### VLOOKUP with Multiple Criteria Including Date Range in Excel (2 Ways)

This article illustrates 2 well-explained examples to VLOOKUP a value that fulfills multiple criteria including a date range in Excel. We frequently ...

Advanced Excel Exercises with Solutions PDF