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

jmcgillis14

New Member
Joined
Sep 24, 2014
Messages
11
ABCD
1
NameNumberNameNumber
2Alex15
Sarah45
3Eric20Steve33
4Steve33
5Seth33
6Sarah45
7Erica50

<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

Well-known Member
Joined
May 8, 2018
Messages
819
Unless you've skipped an important criteria, this appears to be a straight-forward VLOOKUP.

Code:
=VLOOKUP(C2,$A$1:$B$7,2,FALSE)
Fill down.
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,096
Office Version
2019
Platform
Windows
Here is a VBA solution

Code:
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
 

Forum statistics

Threads
1,084,749
Messages
5,379,617
Members
401,615
Latest member
syn_excel

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top