From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using MATCH and INDEX functions together

Using MATCH and INDEX functions together

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using MATCH and INDEX functions together

- In this worksheet called INDEX-MATCH, we've got a Social Security number here, and we'd like to find out the name associated with it, and we'll start with just a single entry here, and you probably already have seen the answer. It's Quinn Collins. Same Social Security number, but imagine we're in a different worksheet. We might have a large list like we see over in column S. Let's begin with the match function here to figure out where this is found in column N. Now, ultimately, what we would like to do is to get the name and that could mean something like a VLOOKUP, but as we'll see, a VLOOKUP will not work here. A combination of match and index will. Let's first match this entry, comma, with the data in column N. The match function looks in a location. Remember, this must be a row or part of a row or a column or part of a column. Can't be a rectangular range, and we're looking so that this is an exact match. After putting in the comma there, see the prompt. Zero for exact match…

Contents