title: Search in Array and Return value using VBA
body: <p>I have an array in VBA that has a string of characters. I need to use lookup function from the Array cells such that whenever the value is found, the corresponding cells in the row get copied to a different Sheet.</p>
  
  <pre><code>Dim Rng As Range
  Dim process() As Variant
  
  Set sh = ThisWorkbook.Sheets("Data")
  Set hc = ThisWorkbook.Sheets("Hourly Cuts")
  Set ds = ThisWorkbook.Sheets("Downtime Summary")
  Set Summary = ThisWorkbook.Sheets("summary")
  
  ds.Activate
  
  process = Range("V2", Selection.End(xlDown))
  a = sh.Range("R1")
  
  For i = 1 To a
      If ds.Range("F", i + 3) = process Then Summary.Range("B", i + 6) = 1
      End If
  Next i
  End Sub
  </code></pre>
  
  <p>How do I use the lookup function using vba?</p>