Excel Formulas Archives

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

Sep 23, 2021 Advanced Excel

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

Sep 23, 2021 Advanced Excel

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

How to Create Dynamic Dependent Drop Down List in Excel

Sep 22, 2021 Excel Formulas

Today I will be showing how you can create a dynamic dependent drop-down list in Excel using both Formulas and Tables. What is a Dynamic Dependent ...

INDIRECT Function with Sheet Name in Excel (4 Criteria)

Sep 23, 2021 Excel Formulas

In Microsoft Excel, the INDIRECT function is generally used to return the reference specified by a text string. In this article, you’ll learn how you ...

How to Reference Worksheet Name in Formula in Excel

Sep 23, 2021 Excel Formulas

We may know how to work with more than one worksheet in Excel. But sometimes while working with more than one worksheet, we have to reference one ...

INDIRECT VLOOKUP in Excel

Sep 23, 2021 Excel Formulas

The INDIRECT function in Excel helps the users to lock the specified cell in a formula. Therefore, without changing the formula itself, we can modify ...

Formula Using INDIRECT INDEX MATCH Functions in Excel

Sep 23, 2021 Excel Formulas

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

Sep 23, 2021 Excel Formulas

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)

Sep 23, 2021 Excel Formulas

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

How to Use IF ISNA Function with VLOOKUP in Excel

Sep 23, 2021 Excel Formulas

One of the most important and widely used functions of Excel is VLOOKUP. But while using VLOOKUP, we may sometimes face errors when the lookup value ...

VLOOKUP with Numbers in Excel (4 Examples)

Sep 23, 2021 Excel Formulas

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

XLOOKUP vs INDEX-MATCH in Excel

Sep 23, 2021 Excel Formulas

In the earlier versions of Excel, we used to use the HLOOKUP, the VLOOKUP, and the INDEX-MATCH functions of Excel to look for a specific value in a ...

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

Sep 23, 2021 Excel Formulas

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

Use of VLOOKUP in VBA to Find Values from Another Worksheet in Excel

Sep 23, 2021 Excel Formulas

Circumstances may arise when you need to use certain VBA codes that execute the operation from different worksheets, like you may need to use VLOOKUP ...

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

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