Cómo funciona.
BUSCARV es una función fundamental de Excel. Busca un valor en la primera columna de una tabla y devuelve el valor de la misma fila desde la columna indicada. Permite automatizar hojas de cálculo, simplificar fórmulas complejas y analizar datos con total precisión en Microsoft Excel y Google Sheets.
💡 En palabras sencillas.
Searches down the first column of a table to find a matching word, then reads across that row to get a value from a column you choose.
"Think of VLOOKUP like sliding your finger down a price catalog. You lookup the item name in the left column, then slide your finger to the right to see the price."
Sintaxis.
Notación Estándar de Excel=BUSCARV(valor_buscado; matriz_buscar_en; indicador_columnas; [ordenado])Argumentos.
A continuación se detallan todos los parámetros aceptados por esta función.
The value to search for in the first column of the table.
Ejemplo:D2The range containing the search column and the return column.
Ejemplo:A2:B6The column number in the table range to return a value from (first column is 1).
Ejemplo:2TRUE = Approximate match, FALSE = Exact match. In almost all cases, set to FALSE.
Valor por defecto: FALSEEjemplo práctico.
Caso de Uso Paso a PasoProduct Pricing Directory
Retrieve a product's price using its exact name.
| Item Name | Price | Stock | Query Item | Item Cost |
|---|---|---|---|---|
| Laptop | 999 | 15 | Tablet | — |
| Monitor | 299 | 8 | — | — |
| Tablet | 449 | 24 | — | — |
=VLOOKUP(D2, A2:B6, 2, FALSE)Evaluates VLOOKUP over the sample table cells, placing the verified output in cell E2.
Generador de fórmula.
Abrir Asistente CompletoPersonaliza los campos de argumento a continuación para generar una fórmula lista para copiar y pegar en tu hoja de cálculo.
=BUSCARV()Comportamiento del resultado.
Returns "Engineering" based on sample evaluation criteria and active cell references.
Buenas Prácticas
- Always set range_lookup to FALSE or 0 to avoid incorrect approximate match returns.
- Lock your table_array range with dollar signs (e.g. $A$2:$C$6) when copying formulas down a column.
Errores Frecuentes
- VLOOKUP can only search from left to right. The lookup value must always be in the first column of the table_array.
- Inserting or deleting columns in the table range shifts the column indices, which breaks VLOOKUP or returns incorrect data.
Compatibilidad de plataforma y versiones.
Matriz verificada con base en los motores de cálculo oficiales de Microsoft Excel y Google Sheets.
Core standard function supported across all modern and legacy Microsoft Excel versions (365, 2021, 2019, 2016, 2013, 2010), as well as Excel for the Web and Mac.
100% compatible with Google Sheets. Uses identical argument order, data types, and standard calculation logic.
Preguntas frecuentes.
Dudas TécnicasWhy is VLOOKUP returning a #N/A error?↓
The #N/A error means the lookup_value was not found in the first column of table_array. Common causes include trailing or leading spaces in cell text, numbers stored as text strings, or omitted range_lookup causing false misses.
Can VLOOKUP look to the left in Excel?↓
No. Traditional VLOOKUP can only search the leftmost column of the table_array and return values to the right. To look up data to the left, use XLOOKUP or an INDEX and MATCH formula combination.
Why should I always specify FALSE as the fourth argument in VLOOKUP?↓
Omitting the fourth argument defaults VLOOKUP to TRUE (approximate match), which assumes your table is sorted alphabetically or numerically. Setting range_lookup to FALSE or 0 guarantees an exact match.