In the attached file, Dept A, B, and C should return the value in the 'Amount' field. However, Dept D should return a $0 value only when the Serial has an exact match within the dataset (under Dept D). If Dept D has a Serial without an exact match within the dataset, then Amount * 20% should be returned. I cannot upload the database due to data sensitivity but the attached file is an example of what I'm looking for (Desired Output field is what the formula should achieve). Please let me know if there is a formula to achieve this.