Find rows of data which match all or majority of criteria in excel

calof1 

If you place your criteria in columns in the range A1:I1 instead of rows as shown in the Matching Data Sheet in the attached, you may use Advanced Filter to get the matching data as per the criteria you set in the range A2:I2.

Place the following code on a Standard Module like Module1:

Sub GetMatchingData()
Dim wsData      As Worksheet
Dim wsOutput    As Worksheet
Dim lr          As Long
Dim dlr         As Long

Application.ScreenUpdating = False

Set wsData = Worksheets("Data Set")     'Data Sheet
Set wsOutput = Worksheets("Matching Data")    'Result Sheet

lr = wsData.Cells(Rows.Count, "B").End(xlUp).Row
dlr = wsOutput.Cells(Rows.Count, "A").End(xlUp).Row

If dlr > 5 Then wsOutput.Range("A6:A" & dlr).Clear

wsData.Range("B3:J" & lr).AdvancedFilter Action:=xlFilterCopy, _
    CriteriaRange:=wsOutput.Range("A1:I2"), CopyToRange:=wsOutput.Range("A5"), Unique:=False

Application.ScreenUpdating = True
End Sub

And then place the following code on Matching Data Sheet Module:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub
On Error GoTo Skip
If Not Intersect(Target, Range("A2:I2")) Is Nothing Then
    Application.EnableEvents = False
    GetMatchingData
    Application.EnableEvents = True
End If
Skip:
Application.EnableEvents = True
End Sub

Once you set any criteria in the range A2:I2 on Matching Data Sheet, the matching Tracker ID would be updated automatically.

Please refer to the attached for more details.