Looking to do a rather involved vlookup

I have a report that I have to make between two different data sources that I put into a workbook on separate pages.  I want to have text show in a field where the data matches from sheet2.  Sheet1 i...