title: copy row values from one sheet to another sheet for the matched records in Excel
body: <p>I have two sheets in an excel workbook and Sheet1 has the following columns:</p>
  
  <p><a href="https://i.stack.imgur.com/ieXsw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ieXsw.png" alt="Sheet1"></a></p>
  
  <p>and Sheet 2 has only ID column:</p>
  
  <p><a href="https://i.stack.imgur.com/NZ3jj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NZ3jj.png" alt="Sheet2"></a></p>
  
  <p>If ID in sheet 2 matches with ID in sheet 1 I want to write col1 and col2 values in sheet1 to sheet 2</p>
  
  <p><a href="https://i.stack.imgur.com/JQAOO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JQAOO.png" alt="enter image description here"></a></p>
  
  <p>I used VLOOK up to identify the matched records but I am manually copying the values of the matched records into sheet 2 and I have to do this for 100,000 rows. I really appreciate if I can get some help.</p>