Gruppe
Funktion
Problem
Was bewirken die Funktionen SVERWEIS, WVERWEIS, INDEX, VERGLEICH sowie die Zielwertsuche?
StandardModule: Modul1
Function myVLOOKUP(rng As Range, _
iResult As Integer, _
ParamArray varSearch() As Variant)
Dim var As Variant
Dim iCounter As Integer
For iCounter = 0 To UBound(varSearch)
var = Application.VLookup( _
varSearch(iCounter), rng, iResult, 0)
If Not IsError(var) Then
myVLOOKUP = var
Exit Function
End If
Next iCounter
myVLOOKUP = "#NV"
End Function