From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

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

XLOOKUP with wildcards

XLOOKUP with wildcards

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

XLOOKUP with wildcards

“

- 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 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. Alright. 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, look up array. I wanted to look in this code 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 wild card character match. And I'm going to close parentheses and enter. Hey, we've got N/A's, of course. To get XLOOKUP to see the code that has AA somewhere in the middle, I'm going…

Contents