title: Retrieving the value of the cell in the same row in the specific column using VBA
body: <p>I'm currently working on the statement that implies, that if any of the cell value in the range of "G3:ED3" in the worksheet named "Matrix", matches the cell value in the range of "H3:H204" in the worksheet named "Staff" and any cell value in the range "G5:ED57" in the "Matrix" worksheet is numeric, then the value of the cell in a column B, that intersects the numeric value, is retrieving to the required cell address in the target template. </p>
  
  <p>Here's what I have tried so far: </p>
  
  <pre><code>    Dim rng1 As Range
      Set rng1 = Worksheets("Matrix").Range("G3:ED3")
      Dim rng2 As Range
      Set rng2 = Worksheets("Staff").Range("H3:H204")
      Dim rng3 As Range
      Set rng3 = Worksheets("Matrix").Range("G5:ED57")
  
      For Each cell In Range(rng1, rng2, rng3)
      While IsNumeric(rng3) And rng1.Value = rng2.Value
      Worksheets("Matrix").Columns("B").Find(0).Row = 
      Worksheets("TEMPLATE_TARGET").Value(12, 4)
      Wend
  </code></pre>
  
  <p>I'm unsure how to define the statement, so the code would automatically retrieve the value of the cell in a column B, that intersects any cell that contains numeric value in the rng3. Any recommendations would be highly appreciated. </p>