title: Find a specific row in a excel range with vba
body: <p>I need to find rows on a sheet that meet given criteria(s).
  I saw several times that authors perform this by filtering based on the search criteria but I don't like this method, so I am using something like this.</p>
  
  <pre><code>Sub fi()
      Dim lastRow As Long
      lastRow = 100
      Dim myRow As Long
      For i = 1 To lastRow
          If Cells(i, 1) = "value1" And Cells(i, 3) = "value2" And Cells(i, 4) = "value3" Then
              i = myRow
          End If
      Next i
  End Sub
  </code></pre>
  
  <p>Does any of you have some good practice to do it on more efficient way? 
  These are a kind of orders with 10 cells by row, but I can find what I need based on three of them. It is s typical sql select statement, but here I cannot use sql.
  thanks</p>