Lookup functions in excel

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

VLOOKUP and HLOOKUP combined Excel formula (with example)

In this article, we will see how to use VLOOKUP and HLOOKUP Combined functions together in Excel formulas. Here we will use VLOOKUP and HLOOKUP ...

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 in Excel using VLOOKUP

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