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

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.
question mark

What does the VLOOKUP function do in Excel?

Select the correct answer

¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 3. Capítulo 4

Pregunte a AI

expand

Pregunte a AI

ChatGPT

Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla

Awesome!

Completion rate improved to 6.67

bookVLOOKUP

Desliza para mostrar el menú

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.
question mark

What does the VLOOKUP function do in Excel?

Select the correct answer

¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

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