Match data in 2 columns and return all results from a 3rd to a single cell

Hi all,
I have a spreadsheet that has 3 columns of data. I need to match results from 2 of the columns and return all the results from the corresponding 3rd column into a single cell. I have found some code that does this for a single search but I don't know how to expand this to search in an additional column. This code is below. Please could someone help?

Please Login or Register  to view this content.

As a starter :

PHP Code: 

Sub Demo1()
         Dim V, W, R&, K$
    With Sheet1
             V = .[F6].CurrentRegion.Value
             W = .[A6].CurrentRegion.Value
        With New Dictionary
            For R = 1 To UBound(W)
                K = W(R, 2) & " " & W(R, 3)
                If .Exists(K) Then .Item(K) = .Item(K) & ", " & W(R, 1) Else .Item(K) = W(R, 1)
            Next
                For R = 1 To UBound(V):  V(R, 1) = .Item(V(R, 1) & " " & V(R, 2)):  Next
               .RemoveAll
        End With
            .[I6].Resize(UBound(V)).Value = V
    End With
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

When I try and use this I get a compile error on New Dictionary. Did you manage to successfully run on the uploaded file? Should it go in thisworkbook or the sheet code?

Thanks

Hi, I'm now getting #NAME? error?

Also, if the data to lookup is on another sheet, how would this be achieved? New file uploaded.

Many thanks.

1) Code needs be pasted in a Standard module.
2) Set the calculation mode to automatic.

brilliant many thanks!

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.