title: Compare data between two tables and update value in another row
body: <p>I have a table named 'Master_Table' with column 'Asset Number'.</p>
  <p>I would like to loop through that column to see if each value is in another table ('Table 'Daily' column 'Asset Number') then update column 'Found' on the 'Master_Table'.</p>
  <p>I managed to loop through a column and check the other table. How do I update a column based on results?</p>
  <pre><code>Sub updateMasterColumns() 'strCol As String)
  
      Dim rng As Range
      Dim cell As Range
      Dim i As Long
  
      Set rng = Worksheets(&quot;Master Sheet&quot;).Range(&quot;Master_Table[Asset Number]&quot;)
      
      For Each cell In rng
      
          If Not IsError(Application.Match(cell, Worksheets(&quot;Daily&quot;).ListObjects(&quot;DailyDump&quot;).ListColumns(&quot;Asset Number&quot;).Range, 0)) Then
              Debug.Print &quot;Value exists&quot;
          Else
              Debug.Print &quot;Value does not exist&quot;
          End If
  
      Next
  
  End Sub
  </code></pre>
  <p>I need it to be table-column specific as the table is growing on a daily basis.</p>