Sep 28 2020 01:09 PM
Currently this formula in Final Match Column it is reading if any of the Attributes match with the description. In this case it does not, I want to expand this formula to say if the attributes do not match then if the notes column state "animal" the Final Match becomes True.
Formula: =IF($A2="","",ISNUMBER(MATCH($G2,$B:$F,0)))
Item | Attribute | Attribute | Attribute | Attribute | Attribute | Description | Final Match | Notes |
Cat | brown | ears | dots | tail | paws | dog | FALSE | animal |
Sep 28 2020 01:21 PM