Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
VLOOKUP | Lookup and Reference
Excel Formulas
course content

Contenido del Curso

Excel Formulas

Excel Formulas

1. Basic Formulas
2. Array Formulas
3. Lookup and Reference

bookVLOOKUP

The VLOOKUP function (short for Vertical Lookup) is one of the most commonly used lookup functions in Excel. It allows you to search for a value in the leftmost column of a table or range, and then retrieve a value in the same row from a specified column. Here's how the syntax of VLOOKUP looks:

lookup_valueThe value to search for.
table_arrayThe table or range where data is looked up.
col_index_numThe column number in the table from which to retrieve the value.
[range_lookup](Optional). If TRUE or omitted, an approximate match is returned (default). If FALSE, an exact match is required.
What does the VLOOKUP function do in Excel?

What does the VLOOKUP function do in Excel?

Selecciona la respuesta correcta

¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 3. Capítulo 4
some-alt