I've been asked to add two new additional criteria to the formula below.
=IFERROR(IF((ISNUMBER(MATCH(D2,'GOSC Docs'!$A$2:$A$16,0))*(D2<>"SMILE_ERR")+(D2="SMILE_ERR")*(O2="B07")+(D2="SMILE_ERR")*(O2="B36"))*(AK2="GOSC")=1,IF(OR(P2="",P2="STR"),VLOOKUP(AF2,'GOSC...