Matching Text as lookup

  • I have 2 sheets with some overlapping data. The only commonality between the 2 sheets is the text. I need to match the text from sheet 1 and sheet 2 and then pull data from subsequent columns to create a unified spreadsheet of information. So for the example I included I want to see Author and Year from sheet 1(based on a match of the text) posted on sheet 2.