I have the following formula, however, I want to add another condition that in Column K, the value has to be "CORRECT" for all matches.
Thanks!
Excel Formula:
IF($C$37="CR Number",
RIGHT(INDEX('[Request Tracker.xlsm]In Progress'!$A$2:$A707,
SMALL(IF($C$25='[Request Tracker.xlsm]In Progress'!$J$2:$J707,
ROW('[Request Tracker.xlsm]In Progress'!$A$2:$A707)-ROW('[Request Tracker.xlsm]In Progress'!$A$2)+1),
ROW('[Request Tracker.xlsm]In Progress'!1:1))),7),"")
Thanks!