Select dataset based on drop down value

Hello all. In this tutorial, let’s look at returning a complete data set based on selected string as drop down value. This tutorial can home handy when you want to pull standard set of metrics for different department in an org or if you want to pull meta-data about certain product’s sales numbers. Let’s workContinue reading “Select dataset based on drop down value”

Indirect Function in Excel

Hello all. Let’s look at Indirect function. Indirect function would return a reference (or reference range) from a specified string. Syntax: =Indirect(ref_text, [a1]) Let’s look at some examples. In the below example, we have one value in each worksheet (sheet1,2&3). Let’s return each of them using the indirect function Next, let’s create a named rangeContinue reading “Indirect Function in Excel”