Hello!
Wondering if could have feedback on writing a formula that excludes specific criteria from a list. I started a formula that saysIF(ISERROR(MATCH(cellA1,lookupcolumn,0))=FALSE.
I’m confused by ISERROR. That essentially returns true if there is an error or false?
I want to write a formula that says ‘if cellB2 is in this list, then exclude but if cell B2 is not in this list, then include. But I’d like to return a true/false statement instead of saying ‘include’ or exclude’
Wondering if could have feedback on writing a formula that excludes specific criteria from a list. I started a formula that saysIF(ISERROR(MATCH(cellA1,lookupcolumn,0))=FALSE.
I’m confused by ISERROR. That essentially returns true if there is an error or false?
I want to write a formula that says ‘if cellB2 is in this list, then exclude but if cell B2 is not in this list, then include. But I’d like to return a true/false statement instead of saying ‘include’ or exclude’