Cross referencing if the cell is blank.

minasamy 

Let's say that the other sheet is named List, with order numbers in column A and the corresponding names in column B.

On the sheet that the macro should act on, names are in column D and order numbers in column F.

You can change all this in the macro.

Sub GetMissingNames()
    ' Change the constants as needed.
    Const ListSheet = "List"
    Const ListNumCol = "A"
    Const ListNameCol = "B"
    Const DataNumCol = "F"
    Const DataNameCol = "D"

    Dim wshData As Worksheet
    Dim wshList As Worksheet
    Dim r As Long
    Dim m As Long
    Dim rngFound As Range

    Application.ScreenUpdating = False
    Set wshData = ActiveSheet
    Set wshList = Worksheets(ListSheet)
    m = wshData.Cells(wshData.Rows.Count, DataNumCol).End(xlUp).Row
    For r = 2 To m
        If wshData.Cells(r, DataNameCol).Value = "" Then
            Set rngFound = wshList.Columns(ListNumCol).Find(What:=wshData.Cells(r, DataNumCol).Value, _
                    LookIn:=xlValues, LookAt:=xlWhole)
            If Not rngFound Is Nothing Then
                wshData.Cells(r, DataNameCol).Value = wshList.Cells(rngFound.Row, ListNameCol).Value
            End If
        End If
    Next r
    Application.ScreenUpdating = True
End Sub