title: How to compare two columns in Excel (from different sheets) and replace values in the corresponding column?
body: <p>I have two excel sheets with same dimension. I need to compare column a in Sheet 1 with column a in Sheet 2, such that I can find any rows with a value "1" in sheet 1, then I need to find the corresponding row in sheet 2 and replace that with NAN. </p>
  
  <p>Any help will be very appreciated.</p>
  
  <p>Thanks</p>