Find matching names from two columns and return corresponding value

[rimshot609]

Column A: I have a list of names from a database.

Column B: I have usernames that correspond with the names from column A.

Column C: I have a list of names from the HR department.

Column D: I have a list of phone numbers that correspond with column C names.

How can I lookup the name from column A and match it with the same name from column C to make a table that contains Usernames, Names, and Phone Numbers?
I should mention that there are more names in the database than the HR names column so creating a table and sorting alphabetically will not work.

 

[=ODIN=]

I can't tell if you are messing with us or not...? Maybe vlookup column A in C?

 

[tonyyy]

rimshot609,

If you prefer a vba approach, you might consider the following...

Sub MatchNames_1025973()
Dim arr1 As Variant, arr2() As Variant
Dim i As Long, j As Long, n As Long
arr1 = Range("A2:D" & Cells(Rows.Count, "A").End(xlUp).Row)
For i = 1 To UBound(arr1, 1)
    For j = 1 To UBound(arr1, 1)
        If arr1(i, 1) = arr1(j, 3) Then
            n = n + 1
            ReDim Preserve arr2(1 To 3, 1 To n)
            arr2(1, n) = arr1(j, 3)
            arr2(2, n) = arr1(j, 2)
            arr2(3, n) = arr1(j, 4)
        End If
    Next j
Next i
Range("F2:H" & n + 1).Value = WorksheetFunction.Transpose(arr2)
End Sub

It's assumed that Row1 is a header row. The resulting table will be placed in Columns F:H.

Cheers,

tonyyy