XLOOKUP for google sheets is a custom function that comes handy when you want to search for things from a table or range using another row.
Ficha actualizada:8 de enero de 2022
Compatible con:
16 mil+
Información general
Sample use case is if we want to find employee name based on their employee number. 
With XLOOKUP google sheet function, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
XLOOKUP for google sheets is an improvement on three existing formulas: VLOOKUP and HLOOKUP which have same syntax however with VLOOKUP you can utilise a column number in the lookup table. The downside of the two formulas is that if the table is changed the whole formula breaks. This is something we have solved in xlookup for google sheets. The other formula is INDEX(MATCH): which is a more sophisticated solution for lookups on data on tables however more difficult for most normal users. This again has been simplified by xlookup for google sheets.

Formula one: XLOOKUPTEXT  
This is the xlookup for use in matching based on text similarity. The formula uses fuzzy lookup matching as well allowing for exact match. The function has the following parameters:
lookup_value: The value to search for If omitted, XLOOKUP returns blank cells it finds in the lookup array.
lookup_array: The column to search the lookup value in.
return_array: The column or columns to return once we find a match.
Threshold: The minimum value of text similarity btwn lookup value and lookup array

Formula two: XLOOKUPNUMBERS
This is the xlookup for use in matching numeric based primary keys. The function has the following parameters:
lookup_value: The value to search for If omitted, XLOOKUP returns blank cells it finds in the lookup array.
lookup_array: The column to search the lookup value in.
return_array: The column or columns to return once we find a match.
[if_not_found] Where a valid match is not found, return the [if_not_found] text you supply. If a valid match is not found, and [if_not_found] is missing, #N/A is returned.
[match_mode] 0 - Exact match. If none found, return #N/A. This is the default.
-1 - Exact match. If none found, return the next smaller item.1 - Exact match. If none found, return the next larger item.


Other additional features that the addon can perform are as listed below:
compare names similarity for google sheets.
vlookup with text similarity for google sheets.
vlookup text contains in google sheets.
Compare address and names similarity.
vlookup approximate match text
vlookup if cell contains a word within 

Información adicional
PrecioNo disponible
Desarrollador
Estado de operador no especificado
Política de privacidad
Términos del Servicio
Xlookup for Sheets solicitará los permisos que se indican abajo. Más información
Xlookup for Sheets necesitará acceder a tu cuenta de Google
Con este permiso, Xlookup for Sheets podrá:
Ver, editar, crear y eliminar todas tus hojas de cálculo de Hojas de cálculo de Google
Mostrar y publicar contenido web externo en las solicitudes y barras laterales de las aplicaciones de Google
Conectarse a un servicio externo.
Ver la dirección de correo electrónico principal de tu cuenta de Google.
Consultar tu información personal, incluida la que has compartido públicamente
Reseñas
Idioma:
Ordenar por:
Google no verifica las reseñas ni las valoraciones. Más información sobre las reseñas
Sin comentarios
Búsqueda
Borrar búsqueda
Cerrar búsqueda
Aplicaciones de Google
Menú principal