MS Excel VBA Question

Hello

I have a worksheet with 4 columns

DateofBusiness   UnitID   CampaignID    Participate

Where Dateofbusiness is each day of year
And CampaignID is a unique number that will be 1 to 100. Each "campaign" will have each day of year, so sheet will have each day of year listed anywhere from 1 to 100 times in column A.
And Participate will be a 1 or blank - this will be the cell I am attempting to select.

To get to the correct "Participant" cell, I need to search through the "CampaignID" column and find the defined one, and then search the Dateofbusiness to find the defined one. I have been able to do this using one of the fields but am looking for a way to do the lookup and select the correct cell using both parameters.

I have been able to use this shared code to find the cell, but again it is only searching with one parameter

thank you for any recommendations

If Trim(FindString) <> "" Then
        With Sheets("TEST001").Range("A:A")
            Set rng = .Find(What:=FindString, _
                            After:=.Cells(.Cells.Count), _
                            LookIn:=xlValues, _
                            LookAt:=xlWhole, _
                            SearchOrder:=xlByRows, _
                            SearchDirection:=xlNext, _
                            MatchCase:=False)
           If Not rng Is Nothing Then
                Application.Goto rng, True
                rng.Offset(0, icid).Select
                ActiveCell.Value = 1
            For x = 1 To iSpan
                ActiveCell.Offset(1, 0).Select
                ActiveCell.Value = 1
            Next x
            Else
                MsgBox "Nothing found"
            End If
        End With