match the description with value entry

[AFatria]

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

Item No.	Quantity	Component	Description	Material	Length	Width	Material Description	Material Description
1			F-11-26	LABEL - REGULER NSF PN.M-1-27-8					Generic
2			F-11-27	LABEL - REGULER NSF PN.M-1-27-8				LABEL - REGULER NSF PN.M-1-27-8

[#2]

@AFatria 

In I2:

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

Fill down.

[#3]

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.

[#4]

@AFatria 

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

=VLOOKUP(...)

to

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