XLOOKUP Function Archives

Conditional Drop Down List in Excel (Create, Sort and Use)

Sep 26, 2021 Excel Basics

In Microsoft Excel, the applications of the conditional or dependent drop-down list are immense in the field of data analysis. And creating this ...

XLOOKUP vs INDEX-MATCH in Excel (All Possible Comparisons)

Oct 10, 2021 Excel Formulas

Today I will make a comparative analysis on XLOOKUP vs INDEX-MATCH in Excel. In the earlier versions of Excel, we used to use the HLOOKUP, the ...

XLOOKUP vs VLOOKUP in Excel (Comparative Analysis)

Sep 23, 2021 Excel Formulas

In Microsoft Excel, you might be well aware of the VLOOKUP function whereas the addition of the XLOOKUP function in Excel 365 has a greater ...

How to Perform Partial Match String in Excel (5 Methods)

Sep 23, 2021 Excel Formulas

Whenever you are handling a wide range of data in your worksheet, partial matching or fuzzy matching is an effective way to find your match quickly. ...

Lookup Partial Text Match in Excel (5 Methods)

Sep 23, 2021 Excel Formulas

In Microsoft Excel, there are several useful methods to lookup partial text matches and then extract data based on that specific match. In this ...

How to Use VLOOKUP If Cell Contains a Word within Text in Excel

Sep 22, 2021 Excel Formulas

In Microsoft Excel, sometimes we have to look for different types of data related to a specific word or information within the text in a cell from ...

How to Lookup with Multiple Criteria in Excel (Both AND or OR Type)

Oct 27, 2021 Excel Formulas

While working in Excel, we are to do this often. We are to look up a particular value in a data set that satisfies one or more criteria. Today I will ...

How to use XLOOKUP function in Excel (7 Examples)

Sep 21, 2021 Excel Functions

There are several lookup functions in Excel to perform various lookup and searching operations easily and swiftly. Today we are going to show you how ...

Top 10 Values Based on Criteria in Excel (Both Single and Multiple Criteria)

Oct 10, 2021 Excel Formulas

Today I will be showing how you can filter out the top 10 values based on any criteria from any set of data in Microsoft Excel. Download ...

How to Find Top 5 Values and Names in Excel (8 Useful Ways)

Sep 20, 2021 Excel Formulas

Microsoft Excel has provided numerous ways to determine the top 5 values or names or both from a huge range of data. In this article, you’ll get to ...