SWITCH Function =SWITCH(expression,value1,result1,default) Simple Example To help explain how SWITCH works, here is a simple example. We need the SWITCH function to return the correct discount percentage for each item of fruit in the list D2:G9. The discounts are listed in the first table A2:B6. The fruit value in column D is our expression –… Read More »Using Excel’s SWITCH Function including SWITCH with VLOOKUP.
Here is our scenario. We have at database of purchases to which we need to apply a discount. The discount applied depends on the product category: A, B or C and the quantity purchased. The lookup tables for each category are on separate sheets as shown below. We are going to achieve this using a… Read More »VLOOKUP Multiple Sheets Names Using the INDIRECT Function
In a previous tutorial we explained how to use SUMPRODUCT to count or sum values based on a single criteria. In this tutorial we want to explore how to include multiple criteria in your SUMPRODUCT formula – multiple criteria using AND or OR logic. Here is our scenario featuring a database of accounts… Counting with… Read More »Excel’s SUMPRODUCT with Multiple Criteria Including AND and OR Criteria