VLOOKUP with multi values

I need your kind support & help to find away to solve this mystery “At least for myself”.

I have two different sheet "in the Attache file" with the same column information:-

What I need is to write a VLOOKUP formula inside sheet 2 under column D2 to select A2 & B2 from Sheet 1 and matching it with A2& B2 from Sheet 2 and if its correct then the name “Mike” in Sheet 1 column D2 will be displayed in sheet 2 column D2, otherwise it will be blank.

OR

What I need is to write a VLOOKUP formula inside sheet 2 under column D2 to select A2,B2 & C2 from Sheet 1 and matching it with A2,B2 & C2 from Sheet 2 and if its correct then the name “Mike” in Sheet 1 column D2 will be displayed in sheet 2 column D2, otherwise it will be blank.

Hope it will be easy to me.

I am using Excel 2007.

BR