Match 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, Input and Result expected in Output.

Thanks,
Naveen.

AttachmentSize
INPUT.JPG22.66 KB
Excel Forum.xlsx9.73 KB
OUTPUT.JPG40.57 KB