Expand Formula

Copper Contributor

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)))

 

ItemAttributeAttributeAttributeAttributeAttributeDescriptionFinal MatchNotes
CatbrownearsdotstailpawsdogFALSEanimal
1 Reply

@amitaj 

 

=IF($A2="","",OR(ISNUMBER(MATCH($G2,$B:$F,0)),$I2="animal"))