MATCH function

Up Your Microsoft Excel Skills Formulas and Functions
2 minutes
Share the link to this page
Copied
  Completed

Transcript

Okay, on the left side, we have confirmed RSVP list. And on the right side we have who actually came in and you can see there's several more people that we have on the actual list than what we started with. We're going to use the match function, the match function can look at a value within another list to see which position it's in. So I can go over and click the lookup and reference category in the Formulas tab, and then select match. So the arguments are going to be first off, what are we looking up, in this case, Amy Watson. Then the lookup array Where are we going to find that value in and it's going to be this list here.

Now since I'm going to keep using them and hit f4, put absolute reference around. It should be dollar sign. around your letters numbers there. So it's always using that fixed range there. And then the match type is going to be zero, indicating that it's an exact match. Okay, so I get eight.

So I start here with William count that's 12345678 is the Annie Woodson is in the eighth position of that list there. Now it's important realize that if Amy Woodson was listed twice in here, it's going to stop at the first one. So make sure that you're working with an original list of values, so there's no duplicates in there. Okay. Now, if I copy this down with the double click, and what's happening here, is I'm going to see an ace, which are errors, meaning that it couldn't find it wasn't available there. So if I wanted to see basically everybody who was on this list, but not another list, I'm gonna get the NAS everybody else is on on the list and you could just see the position.

So for example, William Callahan would be number one on that list there. So that's the match function that can be used to tell you the number of a position that value is located within a list.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.