Excel Magic Trick 1287: SWITCH Function: How to Lookup Formulas, References, or Anything Else
Published March 5, 2016
Views 22.6K | Likes 210 | Comments 65
At a glance
Views
22,668
Likes
210
Comments
65
Performance vs. channel
Outlier score
Engagement rate
More features coming
We're working on new analytics and tools. Stay tuned.
About
Download Excel Files: https://excelisfun.net/files/EMT1287.xlsx Download File: https://excelisfun.net/ 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…
- Published
- March 5, 2016
- Made for kids
- No
More features coming
We're working on new analytics and tools. Stay tuned.