If Formula with 3 Logic didn't Work

So i'm trying to create formula based on 3 logic


On the Stock detail 07 Feb 2022 sheets column Q the logic is:
1. If cells Q7 is match with X7:BF7 then:
2. The E7:F7 must be match with 'ODC'!C2:C28
3. Column G sheet ODC on the exact row must be greater than 0
then either it's "OK" or "CHECK"
or if it didn't match criteria 2 and 3 its "-"

I'm trying to use

=IF(MATCH($Q$5,ODC!$B$1:$B$28,0),IF(AND(ISNUMBER(MATCH(E7:F7,ODC!$C:$C,0)), --(ODC!$G$1:$G$28>0)),"YES","CHECK"),"-")

This is the document
Attachment 767120

I'll be glad if someone willing to help me