Cómo Tener la Función BUSCARX en Excel Si No Está Disponible (¡Súper Fácil!)
Автор: Microsoft Excel for Business
Загружено: 2024-08-13
Просмотров: 5847
Описание:
Código para implementar BUSCARX:
Function BUSCARX(lookup_value As Variant, lookup_array As Range, return_array As Range, _
Optional not_found As Variant, Optional match_mode As Long = 0, _
Optional search_mode As Long = 1) As Variant
Dim lookup_index As Variant
' Busca el índice de la primera coincidencia
If match_mode = 0 Then
lookup_index = Application.Match(lookup_value, lookup_array, 0)
ElseIf match_mode = -1 Then
lookup_index = Application.Match(lookup_value, lookup_array, -1)
ElseIf match_mode = 1 Then
lookup_index = Application.Match(lookup_value, lookup_array, 1)
End If
' Si no se encuentra la coincidencia, devuelve el valor especificado o un error
If IsError(lookup_index) Then
If IsMissing(not_found) Then
BUSCARX = CVErr(xlErrNA)
Else
BUSCARX = not_found
End If
Else
' Devuelve el valor correspondiente del array de retorno
BUSCARX = Application.Index(return_array, lookup_index)
End If
End Function
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: