Nov 12 2022 03:50 AM
SolutionHere is the answer. The formula must be as follows:
=AND(ISNUMBER(MATCH($B5,'Anoter Software'!$B$2:$B$7,0)),ISNA($E5))
See also enclosed sheet.
Nov 12 2022 03:50 AM
SolutionHere is the answer. The formula must be as follows:
=AND(ISNUMBER(MATCH($B5,'Anoter Software'!$B$2:$B$7,0)),ISNA($E5))
See also enclosed sheet.