From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Using XLOOKUP and CHOOSECOLS to return multiple non-adjacent column data

Using XLOOKUP and CHOOSECOLS to return multiple non-adjacent column data - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Using XLOOKUP and CHOOSECOLS to return multiple non-adjacent column data

“

- [Instructor] When you're trying to extract information from a list, you're likely to be using a function called XLOOKUP. It's a powerful function introduced a few years ago, and ultimately it will replace and can replace all uses of VLOOKUP and HLOOKUP. In this worksheet, we've got about 700 rows of data, and for the moment we're seeing information about Susan Carr. Her name's in cell J1 and we can also see her name over in the list it happens to be in row 6 but at different times we'll be using different names and we want to be able to pull out relevant information about this person or that person. Eventually we might set up a pick list to do this, but in pulling out the information, we're going to be using a function called XLOOKUP. And also another function you might not be familiar with called CHOOSECOLS, meaning choose columns. Sometimes we want to pull out information from different columns in a list. So some of…

Contents