title: Compare data in two columns and then copy range of cells
body: <p>I have two spreadsheets in excel. </p>
  
  <p>In spreadsheet 1 I have texts in cells from A1 to A200.
  In spreadsheet 2 I have texts in cells from A1 to A200.</p>
  
  <p>I want to compare all the cells in spreadsheet 1 column A to all the cells in spreadsheet 2 column A. If there is a match between the data I want the cell to output the row the match is on and/or copy a range of cells in spreadsheet 2 B2:F2 to spreadsheet 1.</p>
  
  <p>I have come upon  a few formulas including match(), index(), but can't seem to find the complete way to accomplish this. </p>
  
  <p>Any help?</p>