Filter from 3 Columns

[thbutterflycollector_]

I have a cost ledger which is being reviewed by two parties - they can both allocate it a unique reference number.

Originally the formula was set up so that only one party could review (and I have a dynamic data validation for that):

=FILTER('Disallowed'!$C$7:$C$56,COUNTIF(Raw Data'!N:N,'Disallowed '!$C$7:$C$56)=0)

However I need to update the formula so that another party can also allocate it a reference number in Column AO on the Raw Data Sheet.

On the Raw Data Tab based on single column entry the data validation formula was working fine in Column N:
=IF(M12="False",'Disallowed'!$B$7#)
I've added in another data validation formula in Column AO
=IF($AN12="Yes",$N4, 'Disallowed Cost Register'!$B$7#)

However, Column N is now showing the same unique references twice. I suspect the problem is in the Filter / Countif Formula. Can anyone advise as to how I can capture the second set of unique reference numbers in Column AO?

 

[thbutterflycollector_]

This has now been solved in another thread.