title: Compare two excel sheets and copy data to sheet1
body: <p>This is what I am trying to do...I am very new to Excel and have never created a VLOOKUP code before....two sheets in same excel project.</p>
  
  <p>compare column A from TM Roster to Column B in Sheet2, if it matches, copy Column G from Sheet2 to Column X in TM Roster</p>
  
  <p>I have tried looking at other answers, but I do not know how to change the code/formula to make it work in my workbook.</p>
  
  <p>Thanks so much!!</p>