This is the vba I have below: I have a drop down selection that filters data in another sheet. There are 2 columns in the other sheet that have different names on each. The drop down selection has a selection of names that is found in either one of the columns. How can I get it to filter from both columns for example if its not found in field:=3.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$F$4" Then
Sheets("GOALS ANALYSIS 2.0").Range("A4:HQ368").AutoFilter Field:=3, Criteria1:="*" & Target & "*"
Sheets("GOALS ANALYSIS 2.0").Range("A4:HQ368").AutoFilter Field:=4, Criteria1:="*" & Target & "*"(this is the second one I need)
End If

End Sub