LinkBack URL
About LinkBacks
I missed the error part.
As for the last part of condition 2, what is the cell reference? AV2 contains an error?
Maybe:
=IF(OR(AND(E2="Bridge"),COUNTIF(LIST1,F2)>0),AND(E2="Not Bridge",COUNTIF(LIST2,F2),ISERROR(AV1)),"YES","NO")
I missed the error part.
As for the last part of condition 2, what is the cell reference? AV2 contains an error?
Maybe:
=IF(OR(AND(E2="Bridge"),COUNTIF(LIST1,F2)>0),AND(E2="Not Bridge",COUNTIF(LIST2,F2),ISERROR(AV1)),"YES","NO")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks