Excel Formulas

XLOOKUP vs VLOOKUP in Excel (Comparative Analysis)

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 Use VLOOKUP in VBA (4 Ways)

In terms of searching or seeing some specific values or elements, MS Excel provides various functions. VLOOKUP is one of them. It helps us to search ...

VLOOKUP to Find Duplicates in Two Columns

You may need to compare two columns in Excel to find duplicates or unique. In this article, we are going to show you how to find duplicates from two ...

VLOOKUP with Multiple Matches in Excel

One of the most amazing and widely used functions of Excel is VLOOKUP. So far we have learned to pull out a single match from a range of cells using ...

How to VLOOKUP from Multiple Columns with Only One Return in Excel (2 Ways)

The VLOOKUP function is a game-changer when you have to retrieve information from a range of data in the same or different worksheets. The Excel ...

VLOOKUP with Multiple Criteria in Excel (6 Examples)

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

SUMPRODUCT with Criteria in Excel (5 Methods)

There are situations when you are comparing data between two or more ranges and calculating with multiple criteria, The SUMPRODUCT function is your ...

VLOOKUP to Search Text in Excel

One of the most amazing and widely used functions of Excel is VLOOKUP. The number of tasks that you can execute using this VLOOKUP function is ...

SUMPRODUCT Multiple Criteria (3 Approaches)

Circumstances may demand you to work with multiple criteria within the SUMPRODUCT function. To assist you then, today we are going to show you how 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 ...

VLOOKUP with Drop Down List in Excel

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

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 SUMPRODUCT IF in Excel

SUMPRODUCT is an extremely resourceful function with many purposes. When you are comparing data between two or more ranges and calculating with ...

VLOOKUP Fuzzy Match in Excel

While working with larger data sets, many times we try to filter out similar types of values. One of these types of matching is called Fuzzy Match, ...

ExcelDemy
Logo