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.
Bookmarks