INDIRECT Function Archives

Combine SUMIF and VLOOKUP in Excel (3 Quick Approaches)

Dec 1, 2021 Excel Formulas

In Microsoft Excel, we have to combine SUMIF and VLOOKUP functions to look for a value, and based on that criterion, a sum is calculated from a range ...

How to Make a Drop-Down List Based on Formula in Excel (4 Ways)

Nov 22, 2021 Excel Basics

A drop-down list can help you to select any specific data in seconds. The drop-down list is a great helper when you are working with a large database ...

How to Link a Cell Value with a Drop Down List in Excel (5 Ways)

Nov 22, 2021 Excel Basics

The drop-down list is a great helper When you are working with a large database and you need to pick a specific item from a list. Using a drop-down ...

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

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

Conditional Drop Down List in Excel (Create, Sort and Use)

Nov 22, 2021 Excel Basics

In Microsoft Excel, the applications of the conditional or dependent drop-down list are immense in the field of data analysis. And creating this ...

How to Create Dynamic Dependent Drop Down List in Excel

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

How to use IF Statement to Create a Drop-Down List in Excel

Nov 23, 2021 Excel Basics

It’s quite often that you need to create a conditional drop-down list. The IF function is a useful one while dealing with any “conditional” ...

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 (3 Easy Ways)

Nov 15, 2021 Excel Formulas

Today I will be showing how to reference a worksheet name in formula in Excel. We may know how to work with more than one worksheet in Excel. But ...

INDIRECT VLOOKUP in Excel

Nov 4, 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

Nov 2, 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 Make a Drop Down List in Excel (Independent and Dependent)

Nov 24, 2021 Excel Basics

When analyzing large amounts of data, the use of drop-down lists streamlines the experience. And you can make this drop-down list within a minute in ...

VLOOKUP with Multiple Matches in Excel

Nov 8, 2021 Excel Formulas

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 Formula in Excel with Multiple Sheets (4 Simple Tips)

Nov 9, 2021 Excel Formulas

Today I will be showing how to use the VLOOKUP formula across multiple sheets in Excel. One of the most important and widely used functions of ...

VLOOKUP Formula in Excel with Multiple Sheets (4 Simple Tips)

INDEX MATCH across Multiple Sheets in Excel (With Alternative)

Nov 2, 2021 Excel Formulas

In Microsoft Excel, it’s a common scenario to lookup and then extract data from multiple sheets based on different criteria. The combination of INDEX ...