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.