Vlookup help

ccivitella01 

VlookupComment is not a built-in function, but a custom VBA function (see How to vlookup and return matching value with cell comment?)

You'd need a custom function here too. For example

Function IndexMatchComment(DataRange As Range, ParamArray Conditions()) As Variant
    ' Adapted from Extendoffice
    Dim r As Long
    Dim i As Long
    Dim f As Boolean
    Dim s As String
    Dim xRet As Variant 'could be an error
    Dim xCell As Range
    Application.Volatile
    With Application.Caller
        If Not .Comment Is Nothing Then
            .Comment.Delete
        End If
    End With
    For r = 1 To DataRange.Rows.Count
        f = True
        For i = 0 To UBound(Conditions) Step 2
            If Conditions(i)(r) <> Conditions(i + 1) Then
                f = False
                Exit For
            End If
        Next i
        If f Then
            Set xCell = DataRange.Cells(r, 1)
            IndexMatchComment = xCell.Value
            With Application.Caller
                If Not xCell.Comment Is Nothing Then
                    .AddComment xCell.Comment.Text
                End If
            End With
            Exit Function
        End If
    Next r
    IndexMatchComment = "N/A"
End Function

Use like this in D4 on the Variance sheet:

=IndexMatchComment(Data!$D$2:$D$5,Data!$A$2:$A$5,Sheet5!D$2,Data!$B$2:$B$5,Sheet5!$C3,Data!$C$2:$C$5,Sheet5!$B3)

Fill to the right.