INDEX Function

Create a Unique List in Excel Based on Criteria (9 Methods)

In Microsoft Excel, several methods are available to create a unique list under multiple criteria. The unique list is generally prepared to remove ...

How to Populate a List Based on Cell Value in Excel (6 Ways)

In MS Excel, sometimes we may need to determine or find values based on some criteria or condition from a list. Assuming we have a task plan with the ...

How to Auto Populate Cells in Excel Based on Another Cell

How good would it be if cells get filled automatically? Most of the time we will love that. Today we are going to show you how to auto-populate cells ...

Formula Using INDIRECT INDEX MATCH Functions in Excel

In MS Excel, INDIRECT, INDEX, MATCH functions are the most used functions. These functions can be used to find some specific data from any given ...

How to Use VLOOKUP for Partial Match

There may arise a situation where you need to perform a partial matching within VLOOKUP. To assist you, today we are going to show you how to operate ...

VLOOKUP and Return All Matches in Excel (7 Ways)

There are several ways to apply VLOOKUP or vertical lookup in Microsoft Excel to return data based on multiple matches. In this article, you’ll get ...

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

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

How to Use INDEX MATCH with Multiple Criteria in a Different Sheet (2 Ways)

You may sometimes find yourself in a situation When you are working with a large array of data, and you need to find some unique values or texts but ...

How to Use VLOOKUP for Rows in Excel (With Alternatives)

VLOOKUP function is generally used to look for a value in the leftmost column in a table and the function will return a value in the same row from ...

VLOOKUP with Multiple Matches in Excel

Today I will be showing how to use VLOOKUP to extract multiple matches in Excel. One of the most amazing and widely used functions of Excel is ...

VLOOKUP SUM Multiple Rows (4 Ways with Alternative)

In MS-Excel VLOOKUP is the most used important function to search any data from a dataset or table. In terms of calculation, sometimes we may need to ...

How to Use INDEX and Match for Partial Match (2 Ways)

In MS Excel, instead of seeking something with full text or keywords, we may have to use partial text or keywords to look up desired data and ...

Excel Partial Match Two Columns (4 Simple Approaches)

Depending on the circumstances you may need to compare a couple of columns. The comparison can be done in many forms, one of them is partial ...

How to Use VLOOKUP for Partial Match in Excel (4 Ways)

VLOOKUP function is generally used for searching or finding any elements within a range or table in Excel. We can find any elements with partial ...

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

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

ExcelDemy
Logo