Looking up multiple text items

Sorry I'm not overly hot with excel so please excuse me if my terminology is slighty wayward!

I have 2 spreadsheets, one I've set up myself the other is a dump out from another package so I have no control of how it is presented etc

I've created a simplified version of my problem on the attached. Sheet 1 is mine, sheet 2 is the automated dump.

I need in e5 of my sheet to search sheet 2 column c for text that contains '2007' and 'red dog' and column a for text that = A1, once this has been identified i need it to display the cell in column b of the row that matches the text. Any suggestions on what formula I need?

The icing on the cake would be if I could then have the row in sheet 2 automatically highlighted to show it has being done,

Thanks in advance.

JB