From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Use SWITCH, IFS, and CHOOSE functions, contrasted with XLOOKUP

Use SWITCH, IFS, and CHOOSE functions, contrasted with XLOOKUP - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use SWITCH, IFS, and CHOOSE functions, contrasted with XLOOKUP

“

- [Instructor] When you're trying to look up data in Excel, sometimes you'll use a list. Sometimes you'll use it within a function. You're likely to be thinking of the XLOOKUP function or perhaps its companions, VLOOKUP and HLOOKUP, and those are powerful tools, but there are other functions as well too. And when you're trying to track these down, there might be a slight bit of confusion, at least at first. As you go to the Formulas tab in the ribbon, if you go to Lookup & Reference, you certainly will find in here, and they're alphabetical, of course, you'll see XLOOKUP at the bottom, but also a function in here called CHOOSE up top, but also a function called CHOOSE. Now the other two functions shown in the blue panel to the right are not LOOKUP functions, but yet they have a lot in common with these two functions. SWITCH and IFS are found under the category Logical. Now if you've worked with the IF function, you…

Contents