Find row with multiple matches

[sharky12345]

I need to find a way of identify the row number where specific values are found in multiple columns.

The search criteria is on a Userform and is as follows;

Textbox1 - search column A
Textbox2 - search column B
Textbox3 - search column E
TextBox4 - search column F

Once the row is found I need to store the row number as a variable.

 

[DanteAmor]

Try this

Private Sub CommandButton1_Click()
  Dim wRow As Variant, lr As Long, strg As String
  lr = Range("A" & Rows.Count).End(xlUp).Row
  wRow = Evaluate(Replace("=MAX((A1:A#=""" & TextBox1.Value & """)*(" & _
                                "B1:B#=""" & TextBox2.Value & """)*(" & _
                                "E1:E#=""" & TextBox3.Value & """)*(" & _
                                "F1:F#=""" & TextBox4.Value & """)*(row(A1:A#)))", "#", lr))
End Sub

 

[sharky12345]

Perfect - thank you!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.