## Using Excel’s SWITCH Function including SWITCH with VLOOKUP.

SWITCH Function =SWITCH(expression,value1,result1,default)

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

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…

## VLOOKUP Multiple Sheets Names Using the INDIRECT Function

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.

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

We are going to achieve…

## Excel’s SUMPRODUCT with Multiple Criteria Including AND and OR Criteria

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.

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Here is our scenario featuring a database of…