I want to pick other columns based on col 'Name1"

[philky001]

Hello and good weekend to all, Would like
a result set of Name1, Data1 and Data2 when the name in col Name1 matches the name in col Name2, is that done in vba or in which area;

Name1 Name2 Data1 Data2
Al Bain Win Vung Al@test.com 800-777-7777
Sue Reed Al Bain

 

[DanteAmor]

Try this macro

Sub Macro1()
  With Range("C2:D" & Range("A" & Rows.Count).End(xlUp).Row)
    .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=IFERROR(VLOOKUP(RC2,C1:C4,COLUMN(),0),"""")"
    .Value = .Value
  End With
End Sub