I can't think of a way to do it in one formula. How I would do it is copy column A to a separate tab, then go to Data, Remove duplicates. Assuming you copied the data into column A in the new tab, in cell B2 the following forumla would give you what you want: =IF(COUNTIFS('All Together'!A:A,A2,'All Together'!F:F,"FALSE")>0,"FALSE","TRUE"). Copy that formula down and that will tell you if the PO has had any FALSE hits in column F.