I'm using
=IF(COUNTIFS(Vendors[Supplier Name],[@Vendor],Vendors[PO Type],[@[PO Type]]),"Yes","No")
and it works great but only when both areas have text in them. I need it to still return a true value when both results match even when those cells are blank. Could anyone help? The PO type is blank but in the area it's blank on the other tab, it's still retuning a false.
=IF(COUNTIFS(Vendors[Supplier Name],[@Vendor],Vendors[PO Type],[@[PO Type]]),"Yes","No")
and it works great but only when both areas have text in them. I need it to still return a true value when both results match even when those cells are blank. Could anyone help? The PO type is blank but in the area it's blank on the other tab, it's still retuning a false.