Excel Magic Trick 1287: SWITCH Function: How to Lookup Formulas, References, or Anything Else

Download File: Learn how to: 1. (00:11) Intro to Exact Match lookup SWITCH Function, including a default value. SWITCH in a New Excel 2016 function. 2. (01:13) SWITCH to lookup Text Items and put a Default Value in the cell if the lookup value is not found. 3. (02:52) Compare and contract IFS function, CHOOSE function, VLOOKUP function and SWITCH function 4. (04:44) See how to use VLOOKUP and the IFNA Function with a hard coded lookup table in your formula