INDIRECT Function

Combine SUMIF and VLOOKUP in Excel (3 Quick Approaches)

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)

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)

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)

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)

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

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

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)

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)

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

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

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)

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

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)

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

INDEX MATCH across Multiple Sheets in Excel (With Alternative)

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

ExcelDemy
Logo