From the course: Excel: Advanced Formulas and Functions
Join today to access over 25,300 courses taught by industry experts.
Approximate or tiered matches - Microsoft Excel Tutorial
From the course: Excel: Advanced Formulas and Functions
Approximate or 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 we're 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, their 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 V look 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, let's also…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.