Matching Data and if found pulling data from cell to the left of one of the matching rows

I have two spread sheets that has rows of data. I want to take Sheet 1 and if in any row in columns A, B and E match a row in sheet 2 Column C, D and E then data is pulled from sheet two Column B in the same row that the matching data was found.

Not sure if this is possible or if I am explaining it correctly, but any help is greatly appreciated.

Can you attach a sample workbook showing what you want as your output for the sample data.

Go Advanced -> Manage Attachments -> Upload