Hi,
I am expecting the result to produce "NO APPROVAL REQUIRED", but it is coming up with N/A. is there something wrong with the formula?
the VLOOKUP result of F16 does match Q4
=IF(OR(VLOOKUP(D16,'Approver Data'!O:R,4,0)=Q4,VLOOKUP(F16,'Approver Data'!C:F,4,0)=Q4),"NO APPROVAL REQUIRED","")...