Función de Google Sheets

LOOKUP

Returns a value from a range or array that matches a specified lookup value.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

LOOKUP(lookup_value, lookup_vector, [result_vector])

The LOOKUP function searches for a value in a one-row or one-column range and returns a value from the same position in a second one-row or one-column range. It is often used for simple lookups where data is sorted in ascending order.

Argumentos

lookup_valueobligatorioThe value that you want to search for in the lookup_vector.
lookup_vectorobligatorioThe range containing only one row or one column to search.
result_vectoropcionalThe range containing the value to return; must be the same size as lookup_vector.

Ejemplos

=LOOKUP(102, {100, 101, 102}, {"A", "B", "C"})

Resultado: C

Searches for 102 in the first array and returns the corresponding value from the second array.

Preguntas frecuentes

Does LOOKUP require sorted data?

Yes, for the vector form, the lookup_vector must be sorted in ascending order to return correct results.

Funciones relacionadas

VLOOKUP HLOOKUP XLOOKUP MATCH INDEX