Lookup Functions in Excel

How to Use Excel HYPERLINK Function (8 Examples)

The HYPERLINK Function belongs to the Excel Lookup and Reference functions category. The function aids in the linking of data across several ...

How to Use SORT Function in Excel (4 Examples)

While working in Excel, we often have to sort a range or a table according to some specific values. Excel provides a function called SORT which you ...

How to Use XLOOKUP Function in Excel (7 Examples)

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 ...

How to Use MATCH Function in Excel (3 Examples)

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 ...

How to Use HLOOKUP Function in Excel (8 Suitable Approaches)

In Microsoft Excel, HLOOKUP or Horizontal Lookup function is generally used to extract data from a table or an array based on searching for a ...

How to Use VLOOKUP Function in Excel (2 Examples)

Today I will be showing how you can use the VLOOKUP function of Excel. VLOOKUP Function of Excel (Quick View) Download Practice ...

How to Use FILTER Function in Excel (9 Easy Examples)

Excel 365 provides us a powerful function for automatically filtering our datasets, named the FILTER function. It makes our task easier by using this ...

How to Use VLOOKUP and HLOOKUP Combined Formula in Excel

So,This tutorial will demonstrate how to use VLOOKUP and HLOOKUP Combined formulas together in Excel formulas. Moreover, we can find specific data or ...

Using Excel to Lookup Partial Text Match [2 Easy Ways]

In this article, I will show you how to use Excel to look up partial text matches. For this, we can use VLOOKUP or INDEX MATCH functions combo. In ...

How to Find Duplicate Values Using VLOOKUP in Excel

In this article, we will see the process on how to find duplicate values in Excel using VLOOKUP. We will also see the processes on how to use VLOOKUP ...

ExcelDemy
Logo