match the description with value entry

%3CLINGO-SUB%20id%3D%22lingo-sub-2812063%22%20slang%3D%22en-US%22%3Ematch%20the%20description%20with%20value%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2812063%22%20slang%3D%22en-US%22%3E%3CP%3Eif%20the%20value%20%22J2%22%20%3D%20%22Generic%22%20then%20the%20value%20%22I2%22%20must%20be%20equal%20to%20%22E2%22%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22match%20string.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315217iB0C6B8751EAC3082%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22match%20string.PNG%22%20alt%3D%22match%20string.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%221307%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2276%22%3EItem%20No.%3C%2FTD%3E%3CTD%20width%3D%2279%22%3EQuantity%3C%2FTD%3E%3CTD%20width%3D%2276%22%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2276%22%3EComponent%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FTD%3E%3CTD%20width%3D%22254%22%3EDescription%3C%2FTD%3E%3CTD%20width%3D%22136%22%3EMaterial%3C%2FTD%3E%3CTD%20width%3D%2261%22%3ELength%3C%2FTD%3E%3CTD%20width%3D%22100%22%3EWidth%3C%2FTD%3E%3CTD%20width%3D%22223%22%3EMaterial%20Description%3C%2FTD%3E%3CTD%20width%3D%22302%22%3EMaterial%20Description%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EF-11-26%3C%2FTD%3E%3CTD%3ELABEL%20-%20REGULER%20NSF%20PN.M-1-27-8%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Generic%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EF-11-27%3C%2FTD%3E%3CTD%3ELABEL%20-%20REGULER%20NSF%20PN.M-1-27-8%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ELABEL%20-%20REGULER%20NSF%20PN.M-1-27-8%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2812063%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-2812227%22%20slang%3D%22en-US%22%3ERe%3A%20match%20the%20description%20with%20value%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2812227%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1174041%22%20target%3D%22_blank%22%3E%40AFatria%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20I2%3A%3C%2FP%3E%0A%3CP%3E%3DIF(J2%3D%22Generic%22%2CE2%2C%22%22)%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2816433%22%20slang%3D%22en-US%22%3ERe%3A%20match%20the%20description%20with%20value%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2816433%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1174041%22%20target%3D%22_blank%22%3E%40AFatria%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20I%20understand%20you%20correctly%2C%20you%20should%20change%20the%20formula%20in%20column%20I%20from%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DVLOOKUP(...)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eto%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(J2%3D%22Generic%22%2CE2%2CVLOOKUP(...))%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

if the value "J2" = "Generic" then the value "I2" must be equal to "E2"

match string.PNG

 

Item No.Quantity
 

 

Component
DescriptionMaterialLengthWidthMaterial DescriptionMaterial Description
1  F-11-26LABEL - REGULER NSF PN.M-1-27-8        Generic
2  F-11-27LABEL - REGULER NSF PN.M-1-27-8   LABEL - REGULER NSF PN.M-1-27-8 
          
          
          
          
          
3 Replies

@AFatria 

In I2:

=IF(J2="Generic",E2,"")

Fill down.

thanks a lot for help me,
one more time sorry sir, in "column I" has been filled a formula "Vlookup" which is integrated with the key sentence in "column j", so how do I fill in "column I", with the keyword "Generic" for results that are exactly the same as "column E" but do not eliminate the formula in "column I"

thank's
Rgrd.

@AFatria 

I I understand you correctly, you should change the formula in column I from

 

=VLOOKUP(...)

 

to

 

=IF(J2="Generic",E2,VLOOKUP(...))