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.
Approximate and tiered matches
From the course: Excel: Advanced Formulas and Functions
Approximate and tiered matches
- [Instructor] In this video, we are going to do what you may have heard of as approximate matches. But they're really tiered matches are where assigning a record to a category. You'll see soon. The bottom line is we have to do matches where we don't have exact matches. In this example, we are looking at videos, they're length, and assigning them whether they're extra short, medium, extra long, whatever. So a video that is one hour up to an hour 55 minutes, that's considered extra long. And if you've seen the VLOOKUP video, you should know that VLOOK has to look right. So I cannot look for this length over here, and bring up something from the left. So here's what I have to do. I'm going to just switch these columns. All right. And then I'm going to put this into a table. Format as table. Let's see. We can go with this black color. Yep, the table does have headers, and get rid of those filter buttons. Okay…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.