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

[jmcgillis14]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Name[/TD]
[TD]Number[/TD]
[TD]Name[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Alex[/TD]
[TD]15
[/TD]
[TD]Sarah[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Eric[/TD]
[TD]20[/TD]
[TD]Steve[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Steve[/TD]
[TD]33[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Seth[/TD]
[TD]33[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Sarah[/TD]
[TD]45[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Erica[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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