Return Value to Textboxes based on 2 criterias

[Khanzaki]

Respected members;
I currently have a code which enables me to retrieve data from sheet1 based on value in combo box rec2 ;
However I am looking for a way that will enable me to fetch values based on one additional criteria ie if column A or Range("A:A") to contains text "NEW"

Sheet1.Select
Chk = Application.Match(rec2, Range("B:B"), 0)
If Not IsError(Chk) Then
    For i = 2 To 13
        Me.Controls("rec" & i) = Cells(Chk, i)
    Next i
End If

Basically two criteria
!."NEW
2. rec2.value


Thanks for reading

[mjr veverka]

Attach a sample data file - maximum of several dozen lines of data, no more.
The data should be anonymized to maintain the confidentiality of real data.

[protonLeah]

    If Not IsError(Chk) Then
        If Cells(Chk, "A").Value = "NEW" Then
            For i = 2 To 13
                Me.Controls("rec" & i) = Cells(Chk, i).Value
            Next i
        End If
    End If

[Sintek]

@ protonLeah
What happens if The first found - as per match - rec2 does not have "NEW" in Col A but "OLD" or something else...

This should work...No sample file so untested...

With Sheet1.Cells(1).CurrentRegion
    Chk = Evaluate("=Match(""NEW"" & """ & rec2 & """," & .Columns(1).Address & "&" & .Columns(2).Address & ",0)")
    If Not IsError(Chk) Then
        For i = 2 To 13
            Me.Controls("rec" & i) = Cells(Chk, i)
        Next i
    End If
End With

[Khanzaki]

@sintek sir !
Tried your method and it worked Thankyou so much ; uploading a sample file
@protonleah @mjr veverka Thankyou to you guys for your time !

[Sintek]

@sintek sir !
Tried your method and it worked

Glad you got it sorted...