Del curso: Excel 2016: Advanced Formulas and Functions

Accede al curso completo hoy mismo

Únete hoy para acceder a más de 23.100 cursos impartidos por expertos del sector.

Using MATCH and INDEX functions together

Using MATCH and INDEX functions together

Del curso: Excel 2016: Advanced Formulas and Functions

Comenzar mi mes de prueba gratis Comprar para mi equipo

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…

Contenido