title: Comparing List with Column and manipulating cells
body: <p>I have a list called list_uid and it is all integers. I want to compare it to a sheet column called 'UID' using if and for loops. If it is true, then column on the sheet 'Completed?' will be updated to 'Y'. How am I able to do this?  I tried the scripts but it turns out that the whole column is full of 'Y's</p>
  
  <pre><code>for uid in list_uid:
      if uid in general['UID'].values:
          general['Complete'] = yes
      else:
          general['Complete'] = no
  </code></pre>