The spreadsheets of my life
Dealing with complicated tasks requires good understanding of the basics. The category is meant to shed some light on the building blocks that are used to tackle spreadsheet challenges.
The =CHOOSE() function allows you to define a list and pinpoint a single entry from it to be returned as a result. Since list elements can be both values and references, this solution can be applied in various situations. Read More
The =LOOKUP() function in Excel can return value from a vector that sits against an exact/approximate match in another one. Flexibility can be added in the formula by employing a condition whether some vector elements to be used or not. Read More
Combining the =INDEX() and =MATCH() functions is a way to save on time and possibly some document performance. In this post the simplest use of the functions is used to extract data from a two-dimensional table. Read More