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.
That's certainly better than anything I'd come up with in the past 3 days of working with this, thank you so much. The closest I'd managed to get was something like this:
=VLOOKUP($C2,SiteStatus!A2:B14,2,TRUE)="GO"...but that only ended in confusion. I think it was the partial match condition that was giving me the hardest time. It was the closest I could get though.
