Sort List/Group, if matches value then return a value.

[jmcgillis14]

	A	B	C	D
1	Name	Number	Name	Number
2	Alex	15	Sarah	45
3	Eric	20	Steve	33
4	Steve	33
5	Seth	33
6	Sarah	45
7	Erica	50

<tbody>
</tbody>

I need to be able to Search Column A, find a Match for column C. Once that Matches, I need to Fill Column D with the same number to the right of the cell that matches. For example, if I type in Sarah in C4, I need D4 to bring me back 45. If I typed Alex into C3, D3 needs to return 15.

Thank you for your help.

 

[kweaver]

Unless you've skipped an important criteria, this appears to be a straight-forward VLOOKUP.

=VLOOKUP(C2,$A$1:$B$7,2,FALSE)

Fill down.

 

[alansidman]

Here is a VBA solution

Option Explicit


Sub SarahSteve()
    Dim lrA As Long, lrC As Long, i As Long, j As Long
    Application.ScreenUpdating = False
    lrA = Range("A" & Rows.Count).End(xlUp).Row
    lrC = Range("C" & Rows.Count).End(xlUp).Row
    For i = 2 To lrC
        For j = 2 To lrA
            If Range("C" & i) = Range("A" & j) Then
                Range("D" & i) = Range("B" & j)
            End If
        Next j
    Next i
    Application.ScreenUpdating = True
    MsgBox "Completed"
End Sub