From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using the SWITCH function for formula-embedded selection

Using the SWITCH function for formula-embedded selection

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using the SWITCH function for formula-embedded selection

“

- There's a new function in Excel called SWITCH. You could use it as an alternative to the VLOOKUP function when used as an exact match. You could also use it in place of the CHOOSE function in certain situations. It's not always going to be shorter, but it has one decided advantage - you don't need an external table. In this worksheet called SWITCH, there's a table in columns A and B, and in column F we've got a series of VLOOKUP functions that are calculating the numerical score for each of these ratings. A simple lookup, and we're getting correct answers here. Now, an alternative to this is the SWITCH function. It doesn't need that table over in columns A and B. Now, so that you don't have to watch me type, I've prepared this ahead of time. It's in cell H1. I'll simply drag it into cell F2. And as I double click, you can see how long it is. Now, a similar situation with fewer entries, of course, is going to be not that long. What we've got here is all of the information that table…

Contents