Match Function -- Help required

Hi,

I have tried using Index and match to get out put. Help required for column validation/Match from Worksheet Input ranges (A:A,B:B & $C$2 to $G$2), result required is in Output worksheet column D for same matches for ranges given from input worksheet.

Attached Excel with both worksheets Input and Output : Result expected is in Output Column D.

Thanks,
Naveen.