Excel Formulas Archives - Page 2 of 24

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

Sep 23, 2021 Excel Formulas

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

Sep 23, 2021 Excel Formulas

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

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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

Sep 23, 2021 Excel Formulas

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

Sep 23, 2021 Excel Formulas

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