Expand Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1722027%22%20slang%3D%22en-US%22%3EExpand%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1722027%22%20slang%3D%22en-US%22%3E%3CP%3ECurrently%20this%20formula%20in%20Final%20Match%20Column%20it%20is%20reading%20if%20any%20of%20the%20Attributes%20match%20with%20the%20description.%20In%20this%20case%20it%20does%20not%2C%20I%20want%20to%20expand%20this%20formula%20to%20say%20if%20the%20attributes%20do%20not%20match%20then%20if%20the%20notes%20column%20state%20%22animal%22%20the%20Final%20Match%20becomes%20True.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%3A%26nbsp%3B%3DIF(%24A2%3D%22%22%2C%22%22%2CISNUMBER(MATCH(%24G2%2C%24B%3A%24F%2C0)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22591%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2243px%22%20height%3D%2257px%22%3EItem%3C%2FTD%3E%3CTD%20width%3D%2274px%22%20height%3D%2257px%22%3EAttribute%3C%2FTD%3E%3CTD%20width%3D%2274px%22%20height%3D%2257px%22%3EAttribute%3C%2FTD%3E%3CTD%20width%3D%2274px%22%20height%3D%2257px%22%3EAttribute%3C%2FTD%3E%3CTD%20width%3D%2274px%22%20height%3D%2257px%22%3EAttribute%3C%2FTD%3E%3CTD%20width%3D%2274px%22%20height%3D%2257px%22%3EAttribute%3C%2FTD%3E%3CTD%20width%3D%2292px%22%20height%3D%2257px%22%3EDescription%3C%2FTD%3E%3CTD%20width%3D%2256px%22%20height%3D%2257px%22%3EFinal%20Match%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2257px%22%3ENotes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2243px%22%20height%3D%2230px%22%3ECat%3C%2FTD%3E%3CTD%20width%3D%2274px%22%20height%3D%2230px%22%3Ebrown%3C%2FTD%3E%3CTD%20width%3D%2274px%22%20height%3D%2230px%22%3Eears%3C%2FTD%3E%3CTD%20width%3D%2274px%22%20height%3D%2230px%22%3Edots%3C%2FTD%3E%3CTD%20width%3D%2274px%22%20height%3D%2230px%22%3Etail%3C%2FTD%3E%3CTD%20width%3D%2274px%22%20height%3D%2230px%22%3Epaws%3C%2FTD%3E%3CTD%20width%3D%2292px%22%20height%3D%2230px%22%3Edog%3C%2FTD%3E%3CTD%20width%3D%2256px%22%20height%3D%2230px%22%3EFALSE%3C%2FTD%3E%3CTD%20width%3D%2258px%22%20height%3D%2230px%22%3Eanimal%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1722027%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1722106%22%20slang%3D%22en-US%22%3ERe%3A%20Expand%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1722106%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F812379%22%20target%3D%22_blank%22%3E%40amitaj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(%24A2%3D%22%22%2C%22%22%2COR(ISNUMBER(MATCH(%24G2%2C%24B%3A%24F%2C0))%2C%24I2%3D%22animal%22))%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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