From the course: Excel: Advanced Formulas and Functions

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

XLOOKUP with wildcards

XLOOKUP with wildcards - Microsoft Excel Tutorial

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

XLOOKUP with wildcards

“

- [Instructor] Let's look at XLOOKUP using wildcards. In columns F and G, we've got projects and codes. In column C, we want to put lookup values that will retrieve the appropriate project, but we're going to use wildcards. And I'm going to put this data into a table. The cursor is in the data set. Format as table. Let's grab this, blue. Table has headers. Okay, great. Get rid of the filter buttons. All right, I want to look up the project where the code has AA in the middle. Equals XLOOKUP. Double click. Lookup what? Lookup value. The AA. Comma, lookup_array. I want it to look in this cold column. Comma, return. Return, the project name. comma, if not found. I'm not worried about that. Comma, match mode. This is where we put a two for wildcard character match. And I'm going to close parentheses and enter. Hey, we've got NAs, of course. To get XLOOKUP to see the code that has AA somewhere in the…

Contents