Recursive Lookup in excel

I would like to find all values from the lookup and split them by "OR" if there is more than one .. sample attached
Recursive-Lookup---Sheet1.csv

CalmSoul

Asked: 2014-03-11

Advertise Here

Microsoft Excel

1 Solution

LVL 13

Santosh GuptaCommented: 2014-03-11

pls explain more about "Lookup TABLE", output and type table/sets.

LVL 5

CalmSoulAuthor Commented: 2014-03-11

example attached

LVL 13

Santosh GuptaCommented: 2014-03-11

pls explain the logic

LVL 25

Ejgil HedegaardCommented: 2014-03-11

Put this in a VBA module

Option Explicit

Function RecursiveLookup(Id As Range, Table As Range)
    Application.Volatile
    Dim i As Long, arTable As Variant
    arTable = Table
    For i = LBound(arTable, 1) To UBound(arTable, 1)
        If arTable(i, 1) = Id Then
            If Len(RecursiveLookup) = 0 Then
                RecursiveLookup = arTable(i, 2)
            Else
                RecursiveLookup = RecursiveLookup + " OR " + arTable(i, 2)
            End If
        End If
    Next i
    If Len(RecursiveLookup) = 0 Then
        RecursiveLookup = "NOT FOUND***"
    End If
End Function