From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

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

Error handling: IFNA and IFERROR

Error handling: IFNA and IFERROR

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Error handling: IFNA and IFERROR

“

- [Instructor] Let's look at some error handling. In a previous video, I did show you an XLOOKUP that there is a component for if a value is not found, what do you want XLOOKUP to bring back? That component is also an XMATCH, but let's look at some more basic things. Starting in B3, I have a list of gift cards and I'm suspicious. So this handful, I want to check to see if they're legit. Go equals, MATCH, double click, look up that gift card, comma, look it up in this column, comma, and I want an exact match, so zero. All right, so that six says it's in the sixth position in the column. Now, I'm going to send this down. Okay, so we've got three that were not found in the list. I'm going to wrap this. Go back to the first one, wrap this in IFNA, open parentheses, all of that match, that's the value, comma, IFNA, then fraudulent, close the IFNA parentheses, Enter. Go back, double click. There we go. And we can…

Contents