Forum Discussion
Array partial matching with VLOOKUP
Good day everyone, I'm attempting to use a function similar to VLOOKUP, but instead of searching for a single criteria, I'm looking to get a partial match from one array to another. I've illustra...
Conditional formatting rule formula for GO could be
=SUM( COUNTIFS($C2:$D2,"*"& INDIRECT("Table2[NAME]") &"*") * ( INDIRECT("Table2[STATUS]") = "GO") ) * ( $E2 <= TODAY() )Similar for NO GO
Not sure I understood the logic correctly. You speak about OR logic. With that not clear which rule to apply. Name with GO could be New Unit and at the same time Name with NO GO - in the Old Unit in same row.