One of the earlier “recipes” was about the INDIRECT function. It serves to forward a range as a parameter of SUM, AVERAGE, MAX, MIN or, for example, some other aggregation function. A range is defined as string that is contained in another cell. Let’s show, in one simple example, how this works.
Excel is used to solve many challenges, and among other things it can also serve as a human resources management software. You will find out how to link an employee to a Personnel Data in Excel, and how to easily search them. Many of you who read my blog loved Serbian TV series “Military Academy”. In this “recipe” I used data on several actors from this series (except for names and photos, most of it is fictitious).
The search of data ranges is most often done with the help of LOOKUP functions, where we enter the criteria value, the search range (table) and the column containing the result values. After entering the formula, Excel finds and displays the requested value. There are several more ways to search the ranges when it is done relative to their position, which will be discussed more in the text that follows …