Excel TutorialTutorial

Using Excel’s SWITCH Function including SWITCH with VLOOKUP.

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…

Read More