Tag Archives: CHOOSE

Basic Date Calculations – Power Query vs Excel Formula

Posted on November 19, 2022 by MF

It is quite common to perform date-related calculations when we work with Excel. Before Power Query, we must do it with built-in functions. However, we may not get the results we need with a single function most of the time. … Continue reading →

Rate this:

Posted in Formula, Power Query | Tagged , , , , , , , , , , , | Leave a comment

Interactive Chart is not difficult to make – Part 3/3

Posted on July 26, 2017 by MF

Using Option Button to display different items on chart So far, we have made an interactive chart with check box to highlight items with negative growth; with scroll bar to see more items in a confined space.  In this post, … Continue reading →

Rate this:

Posted in Chart, Excel Tips | Tagged , , | 1 Comment

Three different ways to do case-sensitive lookup

Posted on April 9, 2016 by MF

If you do VLOOKUP, you probably know that one of the limitations of VLOOKUP is case-insensitive.  It means case is not a consideration in the lookup process, where PETER is essentially the same as peter. Hence VLOOKUP will consider that … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , | 3 Comments

Display % of column and % of row in a dynamic way

Posted on January 16, 2016 by MF

This post is intended to give you an introduction of CHOOSE function and Option Button (Form Control). Here’s the situation: We want to display the % of total in a 2-D table.  Nevertheless the % can be of column total … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , | Leave a comment

Perform VLOOKUP with 2 lookup values

Posted on May 11, 2014 by MF

4 different ways to perform LOOKUP with 2 lookup values We know that VLOOKUP is very useful. At the same time, we know that VLOOKUP has its limitations. E.g. VLOOKUP only looks from left to right; VLOOKUP only handle one … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | 38 Comments

3D VLOOKUP – Perform VLOOKUP from more than one table

Posted on April 27, 2014 by MF

Pls have your 3D glasses ready… only if you are going to watch a 3D movie.  You don’t need it for a 3D VLOOKUP. We talked about how to do a 2D VLOOKUP by using MATCH together with VLOOKUP.  With that … Continue reading →

Rate this:

Posted in Formula | Tagged , , , | 3 Comments