excel

Describe excel here.

Overcome Vlookup key limit

Open excel, alt-f11, this workbook - insert module


Function MyVlookup(Lval As Range, c As Range, oset As Long) As Variant
Dim cl As Range
For Each cl In c.Columns(1).Cells
    If UCase(Lval) = UCase(cl) Then
        MyVlookup = cl.Offset(, oset - 1)
        Exit Function
    End If
    Next
End Function
Toolbox
Favorite Categories